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 firstname.lastname@example.org
We will send them to you.