PicoScope to Excel via DDE

Forum for discussing PicoScope (version 5)
Post Reply
MadManInABox
User
User
Posts: 3
Joined: Wed Apr 12, 2006 12:40 pm

PicoScope to Excel via DDE

Post by MadManInABox »

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...

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

Post by Michael »

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

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

Post by MadManInABox »

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?

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

Post by Michael »

Ok,

Are you using the latest version of PicoScope? 5.13.07

Best regards,
Michael
Michael - Tech Support
Pico Technology
Web Support Forum

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

Post by MadManInABox »

michael wrote:Ok,

Are you using the latest version of PicoScope? 5.13.07
Yes

Guest

Post by Guest »

bump


any help would be appriciated..

Post Reply