Unable to get the Open property of the Workbooks class

[JoãoASilva]

Hello!

After solving my last issue in this post, I now get an error on one the computers here at work.

System.IO.File.Copy("Z:\Temp.Folders\JoaoASilva\Template.xlsm", oDestination,True) 'Create template copy
xlWorkbookTemp = xlApp.Workbooks.Open(oDestinationTemp) 'Open excel created by Inventor
xlWorkbook = xlApp.Workbooks.Open(oDestination) 'Open template copy

From the 3 machines I tested on, one of them gets this error:

Unable to get the Open property of the Workbooks class

The odd thing is that it opens the excel created by Inventor, but not the template copy.

They are both .xlsm files, and all the machines have the same version of Inventor, Excel and also the Trust Center definitions within Excel.

I also performed a Repair and Reset of office365 (like this post suggests) on the machine and the problem still occurs.

@johnsonshiue 

Allow me to tag you, has this seems like such a specific error.

Thanks in advance,

JoãoASilva

[bradeneuropeArthur]

Is the z drive a network drive. Use in that case servename not drive name!

[JoãoASilva]

Thanks for the suggestion.

Although it didn't solve the issue, it does seem like a good practice.

Both excel files are on a network drive, and Inventor manages to open one and not the other.

Every terminal is configured in the same way (Network drives, Inventor and excel configs and versions).

And everything is up to date (Inventor 2023.3 Build 359).