Evening Ladies & Gents,
Wonder if some genius could help me out.
I would classify myself as a less than a beginner as truth be told, I know nothing of VBA but have dabbled with some borrowed code to get things going on other spreadsheets.
I have an inherited Excel sheet that uses VBA to communicate with GPI devices to get data and also to get screen shots.
I have 2 laptops to use on 2 identical test stations BUT 1 laptop uses 32 bit and the other uses 64 bit Excel.
For the main routine (changing settings and getting data etc) I have already used the Declare PtrSafe so that the macros run this stage without issue.
However, the macro that gets the screen grab obviously fails with the above error on the 64 bit version of Excel. Section of the code below :
When I run the macro, it stops at the "ArrayPtr(0) = VarPtr(length)" with the VarPtr highlighted. Also the actual Sub name is highlighted in yellow (if that helps at all)
I even downloaded the Microsoft win32api helpfile but that confused me even more.
Hoping that its a simple fix, I place myself in your hands !
Thank You
Tony
Bookmarks