How do I start a new application when I open a file?
 

I have a spreadsheet open in Excel and want to click on and open another
Excel spreadsheet in a seperate Excel application without starting another
Excel application then going to open and finding the file.

How do I start a new application when I open a file?
 

Use the Shell function. E.g.,

Sub AutoOpen()
Shell "excel.exe H:\book1.xls"
End Sub



"jkwillis99" wrote in
message
...
I have a spreadsheet open in Excel and want to click on and open
another
Excel spreadsheet in a seperate Excel application without
starting another
Excel application then going to open and finding the file.