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

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

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

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