Test and Measurement Forum

how to link VBA excel to picoscope

Having problems ? let us know the details here

how to link VBA excel to picoscope

Postby azura » Fri Sep 02, 2005 5:55 am

I don't how to create the code for excel to read the picoscope. Can you help me. :cry:
azura
Newbie
 
Posts: 1
Joined: Fri Sep 02, 2005 5:45 am

Postby Michael » Fri Sep 02, 2005 8:11 am

Hello,

Thank you for your post.

There are two ways for Excel to obtain data from PicoScope hardware or software:

1: Use DDE to dynamically exchange data from PicoScope. This requires PicoScope software to be running.

2: Use the available drivers to write your own Excel Macro. This accesses the hardware directly.

Both have their advantages and disadvantages. DDE is very simple to set up as you can set your scope functions using PicoScope. Triggering and timebase settings are easily accessible and Excel simply imports the raw data. You will need both Excel and PicoScope running to achieve this.

Using the drivers to write your own Excel macro means you can build a different macro for each different test routine. The macro runs when you want and closes the driver as soon as you are finished. Many simple tests can be built but requires knowledge of Visual Basic. You will have to hard write each setting of the scope to achieve triggering and sampling rates.

Visit our Forum on "Writing your own software" to see how others use our drivers.

If you would like the drivers, please visit www.picotech.com/software.html

If you would like Excel DDE example spreadsheets, please email tech@picotech.com We will send them to you.

Best regards,
Michael
Michael - Tech Support
Pico Technology
Web Support Forum
Michael
Zen Master
Zen Master
 
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire


Return to Getting Started

Who is online

Users browsing this forum: No registered users and 1 guest