S
Scott
I have searched this site and found some items that relate to my issue but
everything I have tried does not seem to work.
I am using code to open a new workbook where certain parts of the original
information are copied to. I am then trying to save this new Workbook under
the date that occurs in Range("E2") on a worksheet named Data Entries of the
original workbook entitled Data.xls to a certain file location. The code I
have so far is:
I would like the date to appear right before " Min Out Report.xls"
Any help would be greatly appreciated.
everything I have tried does not seem to work.
I am using code to open a new workbook where certain parts of the original
information are copied to. I am then trying to save this new Workbook under
the date that occurs in Range("E2") on a worksheet named Data Entries of the
original workbook entitled Data.xls to a certain file location. The code I
have so far is:
Code:
Workbooks.Add
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\schoes14\Desktop\Min Out Reports\Min Out
Report.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
I would like the date to appear right before " Min Out Report.xls"
Any help would be greatly appreciated.