Calling Excel File from Macro from other Office Application

[rebeto13]

Hi, can one call a file to be opene from a macro so that it opens in its natural application. I have a powerpoint but i want it to open an excel file as well when its started. Can one do this?

 

[hatman]

Sure, provided you are not looking to control the application, one option is to use the Shell() function.

Here is an example of opening a Word File from Excel... simply change the Application and File/path of the file.

Sub open_app()

    Shell "C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE C:\Temp\Word.doc"

End Sub