Yeah, I have that ignore DDE thing off.
I've tried erasing the %1 at the end, but it keeps coming back! I even
went so far as Removing the Open command and recreating it myself. No
luck!
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
My &open command reads
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e
Use DDE is checked on.
DDE message is same as yours.
One more move..........In Excel go to Button>Excel
Options>Advanced>General
section.
Uncheck "Ignore other applications that use DDE"
Gord
On Tue, 22 Dec 2009 14:06:57 -0500, "shawn"
I tried what you suggested and now I'm getting an additional
notification!
Same thing with Buyer.xlsx there.
Here's what is in the commandline for &open:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e %1
Use DDE is checked off and it says
DDE Message:
[open("%1")]
What happens is I double click the file. I get 1 error message, Excel
freezes up, task manager to end task. Repeat sequence, but get 2 error
messages. Repeat sequence get 3 error messages. Repeat sequence and
sometimes the file opens, sometimes just freezes, sometimes get 4th
error
message.
I can just double click Excel and when it loads goto file and open, but
I
shouldn't have to.
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Your Command line for opening Excel files has lost its double-quotes.
Proper syntax is "C:\your path to Excel\filename"
Without the double quotes Excel is treating each space as a new file
name.
C:\your.xlsx
C:\path.xlsx
etc.
Best to re-register Excel.
Try this first.
Close Excel first and On the Windows Taskbar
1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK
Gord Dibben MS Excel MVP
On Tue, 22 Dec 2009 12:56:45 -0500, "shawn"
Example:
I have an Excel file on my desktop. I double click to open it. When
Excel
opens I get the following messages:
1 - 'C:\Documents.xlsx' could not be found. Check the spelling of the
file
name, and verify that the file location is correct. If you are trying
to
open a file from your list of most recently used files, make sure the
file
has not been renamed, moved, or deleted. --------- Only option is
click
OK.
2 - 'C:\And.xlsx' could not be found. Check the spelling of the file
name,
and verify that the file location is correct. If you are trying to
open
a
file from your list of most recently used files, make sure the file
has
not
been renamed, moved, or deleted. --------- Only option is click OK
3 - 'C:\Settings\ssetnicky\Desktop\J09.xlsx' could not be found.
Check
the
spelling of the file name, and verify that the file location is
correct.
If
you are trying to open a file from your list of most recently used
files,
make sure the file has not been renamed, moved, or deleted. ---------
Only
option is click OK.
Not sure why this is happening, but I do know I might have been into
Explorer's file type for XLS.
Shawn
Give us some more detail. You say Excel "tries to .....". Exactly
what
do you see that makes you think that is what is happening? If
Excel
is
commanded to open a file that doesn't exist, you will get an error
message. Do you get an error message? If you do, what does it say?
What
options are given in that message? What buttons are displayed in
that
error message box? I don't know of anything in Explorer - Tools -
Folder
Options - File Types that would drive Excel to open files that
don't
exist. There is a folder into which can be placed files such that
Excel
will try to open them when Excel opens, but those files obviously
exist.
HTH Otto
I don't know what I did, but now when I open Excel it tries to
open
2
or
3 files that no longer exist. How do I stop this?
I believe it had something to do with Tools -> Folder Options ->
File
Types in that area of Explorer, but I can't figure out what to do
to
make
it work fine again.
