Test and Measurement Forum

PicoScope to Excel via DDE

Forum for discussing PicoScope (version 5)

PicoScope to Excel via DDE

Postby MadManInABox » Wed Apr 12, 2006 12:45 pm

I am using an ADC-10 and I'm trying to get the data to transmit into Excel using DDE.

I run PicoScope and it reads the input as I would predict, however when I enter "=PLW|Current!Value" in excel, excel freezes up and I have to force quit it. PicoScope continues to run fine though.

Please help...
MadManInABox
User
User
 
Posts: 3
Joined: Wed Apr 12, 2006 12:40 pm

Postby Michael » Tue Apr 18, 2006 2:30 pm

Hello,

Try this method.

Run Excel and PicoScope.

Go to the edit menu and select copy as text.

Switch to Excel and select a suitable cell location and right-click paste special.

Then select paste as link.

Excel will now continuously refresh the data from PicoScope.

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

Postby MadManInABox » Tue Apr 18, 2006 2:40 pm

OK, I've tried that method but I still get the same result: Excel locks up and I have to force quit it.

Does it matter that I'm running on XP?
MadManInABox
User
User
 
Posts: 3
Joined: Wed Apr 12, 2006 12:40 pm

Postby Michael » Tue Apr 18, 2006 3:00 pm

Ok,

Are you using the latest version of PicoScope? 5.13.07

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

Postby MadManInABox » Tue Apr 18, 2006 3:02 pm

michael wrote:Ok,

Are you using the latest version of PicoScope? 5.13.07


Yes
MadManInABox
User
User
 
Posts: 3
Joined: Wed Apr 12, 2006 12:40 pm

Postby Guest » Tue Apr 25, 2006 11:31 am

bump


any help would be appriciated..
Guest
 


Return to PicoScope 5

Who is online

Users browsing this forum: No registered users and 0 guests