VBA: Wait for next command till .exe application is opened. How?

Hello,

I am trying to adapt a SolidWorks (CAD program) file with Excel data. So I am programming in Excel VBA. I want Excel VBA to open the SldWorks application, after that opening a SolidWorks file. Opening SolidWork is time consuming, and the opening-time varies on different pc`s
Does someone know how to satisfy that the SldWorks application opening process is completed before running next command in VBA? See code. Sub Combination gives run-time Error 429. (Run-time error '429': ActiveX component can't create object.)
The separate subs are working fine.
(Probably a thread related to this problem already exists, but it is difficult for me to search for something unknown.)

Thanks in advance for your reaction,

Bernard

Please Login or Register  to view this content.

Hello,

if the file extension belongs to SolidWorks then you should use GetObject VBA function to open the file like SolidWorks as well in the same time.