PicoScope to Excel via DDE

 
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoScope
Author Message
MadManInABox
User
User


Joined: 12 Apr 2006
Posts: 3

PostPosted: Wed Apr 12, 2006 12:45 pm    Post subject: PicoScope to Excel via DDE Reply with quote

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...
Back to top
Michael
Guru
Guru


Joined: 07 Jul 2005
Posts: 93
Location: St Neots, Cambridgeshire

PostPosted: Tue Apr 18, 2006 2:30 pm    Post subject: Reply with quote

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
Back to top
MadManInABox
User
User


Joined: 12 Apr 2006
Posts: 3

PostPosted: Tue Apr 18, 2006 2:40 pm    Post subject: Reply with quote

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?
Back to top
Michael
Guru
Guru


Joined: 07 Jul 2005
Posts: 93
Location: St Neots, Cambridgeshire

PostPosted: Tue Apr 18, 2006 3:00 pm    Post subject: Reply with quote

Ok,

Are you using the latest version of PicoScope? 5.13.07

Best regards,
Michael
Back to top
MadManInABox
User
User


Joined: 12 Apr 2006
Posts: 3

PostPosted: Tue Apr 18, 2006 3:02 pm    Post subject: Reply with quote

michael wrote:
Ok,

Are you using the latest version of PicoScope? 5.13.07


Yes
Back to top
Guest






PostPosted: Tue Apr 25, 2006 11:31 am    Post subject: Reply with quote

bump


any help would be appriciated..
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoScope
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group