UltimaSerial How to convert Excel VBA programs from using DataqSerial to UltimaSerial
 

Data logger
UltimaSerial

 

Windaq add-ons
Windaq Add-ons

 

Spectrogram
UltimaWaterfall

 

Ultimaserial XChart
XChart

 

FFT1024
FFT1024

 

Ultimaserial Classroom
Lessons

DATAQSerial is an obsoletted ActvieX from DATAQ to interface with some older versions of Windaq starter kits

If you have one that uses the obsolete 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)

11a) Name the UltimaSerial control UltimaSerial1

12a) Replace all the DataqSerial1 or whatever name you found in step 4 with UltimaSerial1.

Option 2: (this is a lot simpler)

11b) Name the UltimaSerial control DataqSerial1 or whatever name you found in step 4.

Now, you are ready to go!

 

Last update: 02/29/12

Copyright: 2000-2005  www.UltimaSerial.com