SaveCopyAs does not work
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
"Den" wrote in message
...
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
|