Does the double-clicked file open as well as a blank workbook, or only
a blank workbook? What OS are you using? Are you running it on a Mac
or PC for that matter? I shouldn't even attempt an answer without any
information, but here goes:
Assuming you are running Excel in some version of Windows:
You probably need to modify the command to start Excel in the File
Types dialog. (From Windows Explorer, Tools>Folder Options or
View>Folder options depending on your OS. Click the File types tab
and select XLS files. Click Advanced, Select 'open' in the list and
click 'Edit'. You will see the command line used to start Excel.
Scroll to the right so you can see the end of the command.
It should be "C:\YourPath\to\excel\excel.exe" /e $1
Note: If you see the '$1' in another box labeled 'DDE message', do not
include it on the command line. (Windows 2000 may use this format)
The /e is what you are interested in. It opens an Excel session with
no blank workbook. The $1 is replaced by the name of your file, which
will open with Excel. 'c:\YourPath\to\excel\excel.exe' will actually
show the path to your Excel installation, which is obviously correct
because Excel opens when you click a file. Leave this part alone!
-Mike
Whenever I double-click an existing Excel file to open it,
a blank workbook opens. How do I suppress this?
Mike Argy
Custom Office Solutions
and Windows/UNIX applications
Please post on-topic responses to the newsgroup
To e-mail me, remove nospam from the address in the headers
