| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Saving workbook with todays date
Trying to get a macro to copy a pivot table from current workbook to a
separate workbook and save with the current date in the file name, e.g. 04272005 Table.xls. How can you code this in a macro to perform? -- Thanks, SD Look |
|
#2
|
|||
|
|||
|
Activeworkbook.SaveAs Format(Date,"mmddyyyy") & ".xls"
-- HTH Bob Phillips "sd look" wrote in message ... Trying to get a macro to copy a pivot table from current workbook to a separate workbook and save with the current date in the file name, e.g. 04272005 Table.xls. How can you code this in a macro to perform? -- Thanks, SD Look |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
| Setting today's date automatically in Excel. | Excel Worksheet Functions | |||
| Saving as web page for workbook with frozen panes | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Today's Date | Excel Discussion (Misc queries) | |||
Linear Mode
