vba code to execute windows app from excel

Copper Contributor

Does anyone know if you can use vba in excel to call a windows app (downloaded from Microsoft Store) like you can a .exe file? If so, would appreciate help with the code. Thank you, in advance.

 

1 Reply

@Thomas_James 

If your VBA code does not need to interact with the started application (other than starting it, and possibly checking to see if it has finished), see the Shell function.  If it does need to interact, and if the application supports the necessary COM interfaces (which it may well not; it depends on how the application was written), see the COM-related documentation for the application and VBA's CreateObject function.