SaveCopyAs does not work
Yes, I am using the full path. It simply does not work when you open the
file as a link within Internet Explorer. I have tried it on various
machines with various confiurations of IE and operating systems. The
result is always the same.
I have check "rights" on directories. Used different shares and directories,
even local to the machine. Still won't work. SaveCopyas simply does not
work when excel is run within Internet Explorer.
Dennis
"Hank" wrote in message
...
Den,
Are you sure you are using the fully expanded path for your file? The
documentation shows an example for SaveCopyAs as follows (which you probably
already know).
ActiveWorkBook.SaveCopyAs "C:\TEMP\XXX.XLS"
Hank
|