Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Savecopyas without password | Excel Discussion (Misc queries) | |||
SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
SaveCopyAs method | Excel Programming | |||
SaveCopyAs | Excel Programming | |||
SaveCopyAs macro | Excel Programming |