PC Review


Reply
Thread Tools Rate Thread

chart name not saved when save as another file

 
 
haley
Guest
Posts: n/a
 
      8th Jul 2009
Hello,
Could anyone help me with this:
I have a EXCEL file includes charts, when I use the following in macro
to save as another file, the chart names are not saved in the new
file, all the chart names becomes Chart1 Chart2 etc. I checked the
origioanl file in Chart Tools, Layout, Properties, the chart names are
the names appear in the tabs, not "Chart1", "Chart2" etc. Why the
chart names are not saved?

ActiveWorkbook.SaveAs Filename:= _
"S:\DataStructure\IWRS.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

Thanks a lot.

Haley
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save chart (that's on a chart sheet) to html file? JoeFrench Microsoft Excel Charting 0 24th Jan 2008 12:11 PM
how can I get a saved file from before when I save again on it? =?Utf-8?B?eml0YQ==?= Microsoft Word Document Management 2 28th Mar 2007 01:56 AM
can you save multiple documents into 1 saved file? =?Utf-8?B?bGl0dGxlX2JpdDc5?= Microsoft Word Document Management 1 10th Feb 2006 04:08 AM
'document not saved' for 'save' or 'save as' an EXCEL file =?Utf-8?B?SnVkeSBDaHVhbmc=?= Microsoft Excel Misc 1 11th Jul 2005 10:12 PM
Save dialogue box disappears once file is saved David M Wicker Windows XP Help 2 5th Dec 2004 01:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:36 PM.