Trying to update the design table from an external excel worksheet and receive vba run-time error 9 subscript out of range. The error occurs when the program tries to activate the inbedded solidworks worksheet. We have a couple of workstations where the program works, but fails on most. The code is attached below, with the problem code in bold.
Thanks
Found the answer to my problem. The program was trying to activate the excel window using the file extension as part of the name. Going to Control Panel/folder options/View and unchecking 'Hide extensions for known file types' fixed my problem.