No Valid COM I/O Resource Available. Set the I/O Property to a Valid COM I/O Resource.

Updated Nov 30, 2022

Reported In

Software

  • Measurement & Automation Explorer (MAX)

Driver

  • NI-VISA

Operating System

  • Windows

Issue Details

I have a VBA code that uses the VISA-COM Type Library to reference from VBA to talk to a network analyzer. I am able to see the network analyzer in NI MAX and SCPI commands work from VISA Test Panel. The VBA code successfully opens the instrument but crashes when I try to send the command to write the SCPI command.

image001.png

Solution

This error is known to occur due to a bug between VISA and some builds of Excel™ that are not under 16.0.14326.20404. 
  • To verify your Excel™ version open Excel™, then click File» Account» About Excel. You will be able to see the build/version as shown.
Excel buildversion.PNG

If the build/version is later than the previously specified version, a downgrade of Excel™ should solve the issue.

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.