Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Savecopyas without password Ray Clark[_2_] Excel Discussion (Misc queries) 9 July 3rd 08 12:50 AM
SaveCopyAs with a twist Rookie 1st class Excel Discussion (Misc queries) 5 January 21st 07 12:33 AM
SaveCopyAs method Lee Excel Programming 4 February 16th 04 04:41 PM
SaveCopyAs Mark Worthington Excel Programming 4 February 8th 04 06:00 AM
SaveCopyAs macro Baddad007 Excel Programming 1 December 31st 03 12:26 AM


All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"