Forum Discussion

Thomas_James's avatar
Thomas_James
Copper Contributor
Feb 21, 2023

vba code to execute windows app from excel

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

  • SnowMan55's avatar
    SnowMan55
    Bronze Contributor

    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.

Resources