Posted by Mike on August 21, 2001 2:00 PM
I have an Excel 97 workbook that has several pages with a data table at the top reflecting the latest data and a chart at the bottom summarizing the data for the month. The chart at the bottom gets its data from another worksheet (including date formats). Through VBA code I copy the Worksheets, save them to a new worksheet, and email them. When the VBA code saves the worksheets I lose my x-axis (date) formats. The line of code is: ActiveWorkbook.SaveAs FileName:=MyFilename, FileFormat:=xlExcel5. The x-axis has linked to source checked. Any ideas how I can keep my date formats?