User manual

Data Transfer 20
© 2005 ... Velleman
3.2 Data acquisition to Microsoft Excel
Pc-Lab2000 software package includes a DLL
(Dynamic Link Library)
DSOLink.DLL,
installed to
Windows'
SYSTEM32
folder.
This DLL allows you to write custom applications in Excel, Visual Basic, Delphi or any other 32-bit
Windows application development tool that supports calls to a DLL.
Transferring Waveform Data to an Excel Spreadsheet
The example Excel macro shows you how to collect data directly into the spreadsheet from the
Velleman PC oscilloscopes without the need for other software.
1.
Open
Microsoft Excel
and start a new workbook document.
2.
Select the
View / Toolbars
Menu and Select
Forms.
·
The Forms toolbar appears.
3.
Create a
Button
·
In the Forms toolbar click on the "Button" button: the mouse-pointer will become a small
cross.
·
On Excel worksheet, use the mouse to draw a rectangle to mark where you want your
button to appear.
·
When you release the mouse after drawing the rectangle the "Assign Macro" dialog-box
will appear.
4.
Type Macro name:
ReadAll
and click
New
button.
·
Microsoft Visual Basic edit window will open. A subroutine called
ReadAll
has been
created.
5.
Substitute the default text:
Sub
ReadAll()
End
Sub
with the following text in the edit window:
(Use Copy and Paste.)
Option
Explicit
Dim
DataBuffer1(0
To
5000)
As
Long
Dim
DataBuffer2(0
To
5000)
As
Long
Private
Declare
Sub
ReadCh1
Lib
"DSOLink.dll " (Buffer
As
Long
)
Private
Declare
Sub
ReadCh2
Lib
"DSOLink.dll " (Buffer
As
Long
)