Thanks for the quick reply. When I uncheck the "Ignore other applications"
box, then click on an .xls file, Excel starts but does not open the file I
clicked on and does not open a new file either, nothing just Excel. I am
using Excel 2002 by the way. Also does your Word application not work the way
I described. If I click on a Word file.... Word starts and opens the file, if
I click on another Word file, another instance of Word starts and opens the
file I clicked on. I have not changed any settings in Word and this is how it
has worked from day one. Maybe the IS dept. changed it from the default
settings. I should mention that when I open Excel it does not display a
splash screen, it just opens the file I clicked on. I know there is a switch
to disable the splash screen, that is why I thought it would be a simple
matter to add the /n switch to force a "New" instance of Excel for each file
I click on. I have posted to several discussion groups and you are the first
one to think of that trick, it is almost there, but not quite. Does that work
on your machine? Thanks for the help by the way
--
Randy
"Dave Peterson" wrote:
You could try:
Tools|options|General tab|Ignore other applications (check it)
And be aware that turning this setting off sometimes gives errors with workbooks
that contain spaces in their path/name:
C:\my documents\excel\my book.xls
The error will look kind of like:
cannot find c:\my ..
then
cannot find documents\excel\my
then
cannot find book.xls
But you can always start multiple instances, then use File|open to open your
workbooks.
==
And I don't think MSWord actually works the way you describe. But with windows
in taskbar clicked, you get something that looks like what you describe--but
it's still just on instance of MSWord.
Randy wrote:
I want to be able to click an an .xls, Excel spreadsheet file and have it so
when Excel starts it will use the /n switch. I want each file I click on to
start a new instance of Excel. I can easily do this by creating a shortcut,
but I cannot seem to get it to work when I just click on a spreadsheet file.
This is the behavior that Word exhibits if I click on a Word file. I want
Excel to work the same way.
I have seen posts on other sites which have indicated registry changes. I
have tried the suggestions without success. If anyone knows of a tried and
true way of doing this I would be grateful.
Thanks
--
Randy
--
Dave Peterson
|