Test and Measurement Forum

Pico Log export to Excel using DDE

Forum for discussing PicoLog

Pico Log export to Excel using DDE

Postby alexc63 » Thu May 03, 2012 12:13 pm

Hi,

I am currently recording some voltages using the ADC-20. The Pico log software is working fine as expected, but I would like to export the data to Excel in real time. I am using the command "=PLW|Current!Value", simply pasting this into an Excel cell. As soon as I press enter after typing this in, Excel crashes (not responding message).

I am running windows 7 with Excel 2010.

Help anyone? Will be much appreciated.

Note: not much knowledge of DDE or stuff like this in Excell

Thanks.

Alex.
alexc63
Newbie
 
Posts: 0
Joined: Thu May 03, 2012 12:09 pm

Re: Pico Log export to Excel using DDE

Postby Hitesh » Wed May 09, 2012 9:24 am

Please find attached an example Excel file that we have which includes DDE commands. Unfortunately I do not have much experience of DDE programming but I can try to assist further if you require any further help.

DDE PicoLog (multi chn).xls
DDE Example file
(11.5 KiB) Downloaded 315 times
Hitesh

Technical Specialist
Pico Technology
Hitesh
Site Admin
Site Admin
 
Posts: 2063
Joined: Tue May 31, 2011 3:43 pm
Location: St. Neots, Cambridgeshire

Re: Pico Log export to Excel using DDE

Postby alexc63 » Thu May 10, 2012 9:23 am

Thanks Hitesh,

I have tried your macro and whenever I click on the action buttons, Excel just freezes (not responding).

I have installed the VBA converter necessary as well.

Should this just work straight away? Or do I need to make any adjustments to the file you provided?

Many thanks for your help.

Alex.
alexc63
Newbie
 
Posts: 0
Joined: Thu May 03, 2012 12:09 pm

Re: Pico Log export to Excel using DDE

Postby Hitesh » Fri May 11, 2012 11:28 am

Hi Alex,

It appears to be working on my PC after I changed the Cold Junction channel name to Channel 2, and changed the units (although I think this gets updated anyway). I've attached the .xls file and my PicoLog settings file for you to try - use the File -> Open menu item in PicoLog to load the settings file.

Please ensure the following:

  • PicoLog application is open and setup for the ADC-20
  • Open the Excel file and ensure Macros are enabled
  • Click either the 'Get Current Readings' and 'Update readings every second' button

I hope this helps.
Attachments
ADC_20_DDE.pls
PicoLog settings file
(3.25 KiB) Downloaded 205 times
DDE PicoLog (multi chn) - ADC-20.xls
Excel file
(17 KiB) Downloaded 250 times
Hitesh

Technical Specialist
Pico Technology
Hitesh
Site Admin
Site Admin
 
Posts: 2063
Joined: Tue May 31, 2011 3:43 pm
Location: St. Neots, Cambridgeshire


Return to PicoLog

Who is online

Users browsing this forum: No registered users and 0 guests