Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart name not saved when save as another file
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save an Excel 2007 Chart as a xml File. | Charts and Charting in Excel | |||
can I retrieve an xl file that was saved as opposed to save as | Excel Discussion (Misc queries) | |||
Save chart (that's on a chart sheet) to html file? | Charts and Charting in Excel | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) |