SaveCopyAs does not work
Den,
Is this with W2K and SP4 installed ?
NickHk
"Den" wrote in message
...
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
|