Menu 
 |
|
 |
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?
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.
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.
| VBA Syntax | Description |
| WinDaqXLVBA.StartRecording | Start Recording using the settings from the last import. NOTE: If used from a custom form, the form must be hidden before the import will start. |
| WinDaqXLVBA.StopRecording | Stop Recording. |
| WinDaqXLVBA.ShowSetUpForm | Display the set-up form to define WinDaq/XL settings. |