Cannot run macro - error on instantiating PCAN3.PCANClient

Comprehensive CAN monitor for Windows® and its add-ins: Plotter, CANdb Import, Instruments Panel, and J1939
Post Reply
togs-bng
Posts: 2
Joined: Wed 19. Dec 2018, 20:58

Cannot run macro - error on instantiating PCAN3.PCANClient

Post by togs-bng » Wed 19. Dec 2018, 21:16

When I attempt to run a macro now, I often encounter an error similar to the following:
Macro Error on instantiating PCAN3.PCANClient object
Macro Error on instantiating PCAN3.PCANClient object
pcan-macro-error.gif (5.96 KiB) Viewed 5485 times
This started happening after I set up PCAN Explorer 5 on my new Windows 10 machine. It was never an issue when I was running Windows 7. I'm not sure if that's a factor, but thought I'd mention it.

I've isolated the error to the inclusion of the CreateObject() call that instantiates the object:

Code: Select all

  Dim MyClient
  Set MyClient = CreateObject("PCAN3.PCANClient")
The error isn't very descriptive so I'm not sure why it's tripping on this.

In VB (but not VBA), I could instantiate the object using early binding (e.g. Dim MyClient As New PCAN3.PCANClient) but this does not work in VBA, both of which I'm quite rusty at!

Any insights would be greatly appreciated!

M.Maidhof
Support
Support
Posts: 1751
Joined: Wed 22. Sep 2010, 14:00

Re: Cannot run macro - error on instantiating PCAN3.PCANClie

Post by M.Maidhof » Thu 20. Dec 2018, 09:58

Hi,

which PCAN-Explorer 5 version do you use?

best regards

Michael

togs-bng
Posts: 2
Joined: Wed 19. Dec 2018, 20:58

Re: Cannot run macro - error on instantiating PCAN3.PCANClie

Post by togs-bng » Sat 22. Dec 2018, 00:17

Thanks for the response!

I was running PCAN Explorer 5.3.2.808, but as soon as you asked me the question, I downloaded/installed 5.4.2.902. I haven't rebooted my Win10 machine yet, but simply installing 5.4.2.902 has allowed me to run my old macros without problem now, including the CreateObject("PCAN3.PCANClient") call.

Odd, since I didn't need to upgrade PCAN Explorer on my Win7 machine. But, problem solved!

User avatar
PEAK-Support
Sales & Support
Sales & Support
Posts: 1646
Joined: Fri 10. Sep 2010, 19:34

Re: Cannot run macro - error on instantiating PCAN3.PCANClie

Post by PEAK-Support » Sat 22. Dec 2018, 13:45

Thank you for that feedback - looks like a lack of authorization with the older Explorer and the latest Windows 10 Uptades.
--------------------------------
PEAK-System Technik
Technical Support Team
support[at]peak-system.com
-------------------------------

Post Reply