I have a simple Excel Workbook with many worksheets within. I have a simple macro that will extract the selected sheet and allow me to save it individually. For some reason all date fields within the worksheet are changed when the worksheet is copied out. For example if the date was 8/6/2007 in the original worksheet, then when I run the macro and copy the sheet out the date will be changed to 8/5/2003. Any suggestions as to why and how to fix? I'm using Excel 2003 and Visual Basic 6 (below is my simple macro). Thanks for any input.
Sub ExtractWeekly()
'
' ExtractWeekly Macro
'
'
Sheets("Weekly 1").Select
Sheets("Weekly 1").Copy
MsgBox ("Please save this weekly report as a separate file. Your original weekly is still contained within the original workbook")
End Sub