![]() |
How to convert Excel VBA programs from using DataqSerial to UltimaSerial | |
|
Let UltimaSerial unleash the power of your Windaq Starter kit!
Lessons on how to use UltimaSerial
|
If you want to start a Excel spreadsheet using UltimaSerial to acquire data, please click here. If you have one that uses DataqSerial and want to convert it to UltimaSerial to take advantage of the extra power, follow the steps below: Before you proceed, please backup the VB program you want to convert and install UltimaSerial Click here if you are converting VisualBASIC program. 1) Open the Excel spreadsheet 2) Select Tools->Macro->Visual Basic Editor to show the VBA codes 3) In the Project Window (Use View->Project Explorer to enable it if it is not on your desktop), open the VBA project. At this point, you may need to supply a password if it is protected. 4) Locate DataqSerial control in the form listed in Project Window, and write down its name, which is usually identified itself as DataqSerial1 if you use Excel samples provided by DATAQ. 5) Delete DataqSerial from the form. 6) Use View->Toolbox to enable the toolbox if it is not on your desktop. 7) Right-click on the toolbox and you will see an option called Additional Controls... 8) Select it and you will see all the controls available on your system 9) Find and enable the UltimaSerial control from the component list. At the same time, remove DataqSerial from the component list 10) Insert UltimaSerial to your form. At this point, you have two options: Option 1: (this is good for future reference)
Option 2: (this is a lot simpler)
Now, you are ready to go!
Last update: 07/15/07 Copyright: 2000-2005 www.UltimaSerial.com
|
|