Test and Measurement Forum

search ps4000.xls

Post your VB and VBA discussions here

search ps4000.xls

Postby pc-baerli » Sat Apr 04, 2009 10:00 pm

Hi,

i search the ps4000.xls file - can anyone send me this file ?

thanks pc-baerli
pc-baerli
Active User
Active User
 
Posts: 5
Joined: Fri Apr 03, 2009 10:09 pm
Location: Switzerland

Postby ziko » Tue Apr 07, 2009 4:00 pm

Hi please find the file attached, it is not yet in our SDK.

Kind regards
Attachments
ps4000.zip
(287.08 KiB) Downloaded 265 times
ziko
Zen Master
Zen Master
 
Posts: 1705
Joined: Fri Dec 01, 2006 10:03 am
Location: St Neots

ps4000.xls it dosn't work

Postby pc-baerli » Sat Apr 25, 2009 8:40 pm

Today i want to make a datalogging file with the ps4000.xls, but the file ps4000.xls dosn't work correctly on my computer . there comes many errors from the makro.
Please can you test the file , and correct it, because i am not a computer programmer

thanks for your help
pc-baerli
pc-baerli
Active User
Active User
 
Posts: 5
Joined: Fri Apr 03, 2009 10:09 pm
Location: Switzerland

Postby Robin » Mon Apr 27, 2009 7:49 am

Hi

I have just checked the posted example and it runs without errors.

What errors do you get?

Robin
Robin
Zen Master
Zen Master
 
Posts: 558
Joined: Fri Sep 19, 2008 10:17 am

Postby pc-baerli » Mon Apr 27, 2009 7:40 pm

Hi,
This is the error message from the example. I work with microsoft excel 2003 SP3 and win xp sp3

thanks for your help
john[/img]
Attachments
laufzeitfehler_453.JPG
laufzeitfehler_453.JPG (15.97 KiB) Viewed 4293 times
pc-baerli
Active User
Active User
 
Posts: 5
Joined: Fri Apr 03, 2009 10:09 pm
Location: Switzerland

Postby Robin » Tue Apr 28, 2009 8:02 am

My German is not too good I'm afraid!

Have you installed PicoScope 6? Do you have ps5000.dll and ps5000wrap.dll (from the posted zip file) in c:\windows\system32?

Robin
Robin
Zen Master
Zen Master
 
Posts: 558
Joined: Fri Sep 19, 2008 10:17 am

Postby pc-baerli » Tue Apr 28, 2009 8:07 pm

Hi,
Now it works. The file ps4000wrap.dll in the SDK from your website is only 8kb and the new from your zip-file is 52kb. i take the new and bigger one and it works
Now i will "learning by doing" with the ps4000.xls -> how it works.

One wish i have, that the picolog software also works with the 4424 !
or that it give an other program to make logging easyer.

thanks for your help
john
pc-baerli
Active User
Active User
 
Posts: 5
Joined: Fri Apr 03, 2009 10:09 pm
Location: Switzerland

doubts on ps4000.xls

Postby madhu » Thu Jun 04, 2009 3:19 pm

Hi,
I'm trying to run ps4000.xls along with PicoScope 4000 series (4424).I'd some doubts on that:
1.The maximum possible number of time samples would be limited by the maximum number of rows in excel (~65000), right?
2. Is there any way to simultaneously view the graph during the collection of the data points from the 2 channels?

Thanks,
Madhu
madhu
User
User
 
Posts: 2
Joined: Thu Jun 04, 2009 3:12 pm
Location: Salt Lake City

Postby Robin » Thu Jun 04, 2009 3:50 pm

Hi

If you place the data in more than one column, you should be able to capture more than 65000 samples in the spreadsheet. Give a try.

Yes, you can collect data from both channels in Excel.

Hope this helps

Robin
Robin
Zen Master
Zen Master
 
Posts: 558
Joined: Fri Sep 19, 2008 10:17 am

Problems while running ps4000.xls

Postby madhu » Thu Jun 04, 2009 7:51 pm

1. Can't we open the Picoscope 6 screen while running the ps4000.xls macro? When I tried that, it gave an error box " Unit not opened". I want to instantaneously view the graph as it is collecting data.

2.After I run the excel macro, the light on the Picoscope goes off during data collection. But when I run the Picoscope 6, it blinks frequently. Why is that?

3. The voltage values from one channel were erroneous. How is the calibration done in the program? I see they are dividing the counts by 32767 and then multiplying by 20000 mV. How is this decided?
madhu
User
User
 
Posts: 2
Joined: Thu Jun 04, 2009 3:12 pm
Location: Salt Lake City

Postby Robin » Fri Jun 05, 2009 7:40 am

Hi

1. No

2. The light is on either when the scope is connected, but not opened or when it is transfering data. The Excel example opens the scope transfers a single block of data and then closes the scope. With PicoScope, the scope is opened when the application starts and when it is running, blocks are collected continually.

3. 20000 is used because the 20 V range is selected in the call to ps4000SetChannel
Robin
Zen Master
Zen Master
 
Posts: 558
Joined: Fri Sep 19, 2008 10:17 am


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests