how to link VBA excel to picoscope

Having problems ? let us know the details here
Post Reply
azura
Newbie
Posts: 1
Joined: Fri Sep 02, 2005 5:45 am

how to link VBA excel to picoscope

Post by azura »

I don't how to create the code for excel to read the picoscope. Can you help me. :cry:

Michael
Advanced User
Advanced User
Posts: 656
Joined: Thu Jul 07, 2005 12:41 pm
Location: St Neots, Cambridgeshire

Post by Michael »

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

Post Reply