ExcelBanter - View Single Post - Saving a Workbook using info from a Cell???

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:

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.