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

[jkwillis99]

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.

 

[Chip Pearson]

Use the Shell function. E.g.,

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



message
news:[email protected]...