Opening multiple excel files

[ajg1978]

Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Have a query on Excel 2007 I am hoping you can help me with. I often have the need for 2 instances of Excel to be running on seperate screens. When I open the various spreadsheets they all open up in just one instance of Excel (it appears to be whichever one was opened first). I would like to be able to determine which instance of Excel a certain spreadsheet opens in, do you know if there is a way of doing this?
<o> </o>
I know I could go to that instance and use file>open etc but most of the spreadsheets I use are desktop shortcuts to save me navigating to a deep folder directory.
<o> </o>
Thanks in advance.
<o> </o>
Adam

 

[CWatts]

Your shortcuts are probably links to the actual excel file, which would be the same as doubleclicking on that file itself which defaults to the first instance of excel.

For example the shortcut would be:
C:\x\Book2.xlsx

You need to manually set up your shortcuts to open a new instance of Excel, but open with that workbook open, like so:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" C:\x\Book1.xlsx

Or Multiple workbooks:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" C:\x\Book1.xlsx C:\x\Book2.xlsx

Hope that helps!