View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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.