SaveCopyAs does not work

[Den]

Has anyone run into this before??

I have a link to a spreadsheet on our intranet. When I click on the link, I
am asked if I want to open the file or save it localy. If I open the file
in internet explorer (any version) then a piece of code like this

ActiveWorkbook.SaveCopyAs (filepath)

does not work. I just get an error message that it failed.

But if I save the file locally and then open it in Excel, the code works
fine.

Any suggestions, other than just give my people instructions to save it
locally first.

Dennis

 

[NickHK]

Den,
I have similar problem with network files opened through Excel, where part
of the path/file name contains non ANSI character. My computer is English
W2K with English Office 2K, network is traditional Chinese.

Do .SaveAs or .Save work as expected ?

NickHK

 

[Guest]

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]

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

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).

 

[NickHK]

Den,
Is this with W2K and SP4 installed ?

NickHk

 

[Steve Garman]

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.