I get the same problem, Den.
I assume it's some sort of half-baked attempt at anti-worm protection.

In the end, it's probably easiest to find a workaround that works with
..SaveAs instead.

Or to give instructions to the users to save the file before opening it.


Den wrote:
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