View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_2_] NickHK[_2_] is offline
external usenet poster
 
Posts: 29
Default 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