| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enter current date automatically in filename
Excel 2000
When saving a file in a Macro, I want to automatically insert the current date in the file name. ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\John\My Documents\Books(DATE HERE).xls", FileFormat:=xlNormal _ , CreateBackup:=False Result: Books01/25/07.xls |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enter current date automatically in filename
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\John\My Documents\Books" & Format (Date,"yymmdd") & ".xls", FileFormat:=xlNormal HTH, CoRrRan ?B?TWVnYWRyb25l?= wrote in : Excel 2000 When saving a file in a Macro, I want to automatically insert the current date in the file name. ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\John\My Documents\Books(DATE HERE).xls", FileFormat:=xlNormal _ , CreateBackup:=False Result: Books01/25/07.xls |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Linear Mode
