| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a Workbook using info from a Cell???
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Losing Cell Protection When Saving Workbook | Excel Discussion (Misc queries) | |||
| Losing Cell Protection When Saving Workbook | Excel Programming | |||
| Saving Worksheet from Workbook with Names from Cell Values | Excel Programming | |||
| How can I link one cell to a list of info in another workbook? | Excel Discussion (Misc queries) | |||
| How do I create a workbook that links info in cell to a calendar? | Excel Worksheet Functions | |||
Threaded Mode
