chart name not saved when save as another file

H

haley

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controling Chart Names 4
Saving Chart Names in Excel 2007 1
45 seconds to save a file, why so long? 1
chart to email 3
Save File in different way 0
Hiding an Excel file using VBA 1
IS THERE ANYONE WHO CAN SOLVE MY PROBLEM ..(JOEL , MIKE H , RON ,PETER , BOB) ANYONE.... 0
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0

Top