Excel VBA using VISA crashing (Oct 2021)

[DP_Apps]

Hello,

I have been using Excel and Word to interface to test equipment (oscilloscope).

Recently (Oct 2021) Excel is crashing when I try to connect the scope (or any equipment on my GPIB bus).

    Set SCOPE1.Command.IO = io_mgr.Open("GPIB:: 12")

My code is ok as it has always worked before.

Similar code in Word is working fine --> hardware interface and VISA drivers are ok.

Looking and the bus data using Agilent Connection Expert IO Monitor I can see the the connection to the equipment is being made but Excel crashes - monitor file attached.

Before I try to roll back the Excel version I'd like to eliminate any other possible causes.  Has anyone seen similar problems lately?

Thanks,

D.

[Iwa6 · Accepted solution]

Hello,

If you are using Excel 16.0.14430.xxxxx, VISA is probably crashing due to a bug in Excel. (I did too)
In my case I avoided it by downgrading Excel to 16.0.14326.20404.

By the way, this is a NI bulletin board, the Keysight VISA topic is out of place.
(However, this issue occurs with both Keysight VISA and NI-VISA.)

[Iwa6]

The latest build 16.0.14827.20158 resolves this issue.

I think you can apply this update if you have the latest channel contract with Office for Microsoft 365.

[DP_Apps · Accepted solution]

Hi Iwa6,

Thanks for this.  This has worked on for me.

Regards,

D.