Test and Measurement Forum

PS3000.xls not finding PS3000.dll

Post your VB and VBA discussions here

PS3000.xls not finding PS3000.dll

Postby _Biggles » Mon Sep 17, 2012 4:56 am

Hi,
I'm running a PS3424 under a fairly old system - (Excel 97 running under Windows 2000 professional). The Picoscope and Picolog programs work perfectly. When I run the PS3000.xls macro I get a 'runtime error "53" File not found ps3000.dll.

I have tried putting the file in the current Excel diectory, in the pico directory and in the winnt/system directory - all to no avail.

Any suggestions?

Ian
_Biggles
Newbie
 
Posts: 0
Joined: Mon Sep 17, 2012 4:46 am

Re: PS3000.xls not finding PS3000.dll

Postby Martyn » Mon Sep 17, 2012 6:19 am

Try editing the macro and adding in the full path in the function declarations.
Martyn
Technical Specialist
Martyn
Site Admin
Site Admin
 
Posts: 2280
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: PS3000.xls not finding PS3000.dll

Postby _Biggles » Mon Sep 17, 2012 11:43 pm

Hi Martyn,

Tried that - still get error 53 and File Not Found c:\temp\PS3000.dll.

The DLL is in the registry as well. I will try on another computer today an d get back to you.

Ian
_Biggles
Newbie
 
Posts: 0
Joined: Mon Sep 17, 2012 4:46 am

Re: PS3000.xls not finding PS3000.dll

Postby Martyn » Mon Sep 24, 2012 9:04 am

Can you try putting the xls macro in the Picolog directory and run it from there
Martyn
Technical Specialist
Martyn
Site Admin
Site Admin
 
Posts: 2280
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: PS3000.xls not finding PS3000.dll

Postby Cisco » Tue Oct 16, 2012 11:53 pm

Hi

I have the same issue as Biggle except that I use a 3405A picoscope and running on a Windows 7 64 bits computer:
run-time error '48'
Fine not found: ps3000a.dll


Before that I got this error:
Compile error: The code in this project must be updated for use on 64-bit systems


that I solved replacing all the "Declare" by "Declare PtrSafe".

I tried to give the absolute path to ps3000a.dll: C:\Windows\System32\ps3000a.dll
and moving the excel file to the picoscope installation path: C:\Program Files (x86)\Pico Technology\PicoScope6
with no success...

Could you please advise on this error?
I noticed also a PS3000a.dll file in the SDK directory, is that the same dll than the one from the installation directory?

Thank you.
Cisco
Newbie
 
Posts: 0
Joined: Tue Oct 16, 2012 11:36 pm

Re: PS3000.xls not finding PS3000.dll

Postby Martyn » Fri Oct 19, 2012 9:32 am

Are you running 64bit or 32bit Excel, you will need to use the latter to hook into our dll.
Martyn
Technical Specialist
Martyn
Site Admin
Site Admin
 
Posts: 2280
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots


Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests