Product Quick Links

• Data Acquisition
• 
• Data Logger
• 
• Chart Recorder
• 
• Temperature Data Loggers
• 
• Humidity Data Loggers
• 
• Temperature and Humidity Data Loggers
• 
• 4-20 mA Current Loop Data Loggers
• 
• Voltage Data Loggers
• 
• USB Data Loggers
• 
• USB Data Acquisition
• 
• Ethernet Data Acquisition
• 
• Event Data Loggers
• 
• USB DAQ

Find the right product for you
with our Product Screener

Developer Network

Browse all sample programs

Visual Basic 6.0

Visual Studio.NET

LabView

MATLAB

C++

Access

Linux

ODBC

SQL

Submit Code

Developer Forum

3rd Party Software

Add-ons

DATAQ Instruments Developer Network

VBA for Excel and WinDaq/XL

	Download Example VBA for Excel and WinDaq/XL Programs
	Need Help? Download the ActiveX Help file or post a question to the Developer Support Forum.

Use WinDaq/XL to port data in real time from WinDaq to a Microsoft Excel spreadsheet. FREE 60 day Trial. Click here to learn more.

How do I add DATAQ ActiveX controls to my project in Excel - Visual Basic for Applications? | How do I Start and Stop WinDaq/XL from VBA?

How do I add DATAQ ActiveX controls to my project in Excel - Visual Basic for Applications?

STEP 1: To add the DATAQ ActiveX components to your Excel project, click Tools>>Visual Basic Editor (Alt+F11) to open the VBA screen.

STEP 2: Add a form to your project. While the form is selected, click Tools>>Additional Controls.

From the Additional Controls box, select the DATAQ ActiveX Controls that you want to add to your project (DataqSdk, DataqSerial, DQChart, ReadDataqFile, WinDaq, WriteDataqFile, WWB), click OK.

The selected DATAQ ActiveX Controls will now appear in your toolbox and you can add them to your form.

How do I Start and Stop WinDaq/XL from VBA?

It is possible to Start and Stop WinDaq/XL from Visual Basic for Applications (VBA) in Microsoft Excel.

Step 1: Add WinDaqXLVBA Add-In as a Reference to your VBA project.

Go to Tools>>References and put a check mark next to WinDaqXLVBA.

If WinDaqXLVBA does not appear as an available reference you may not have the latest release of the WinDaq/XL software. Version 1.42 or greater is needed. Click here to download the latest version.

Step 2: Use WinDaqXLVBA functions to Start Recording, Stop Recording, and display the set-up form.