| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename file based on current date
Hi guys,
I want to rename excel file based on current date and i would prefer the format as "ddmmyy". Here is part of the coding: ActiveWorkbook.SaveAs Filename:= "C:\qadzidr\My Documents\29Apr05am.xls" _ , FileFormat:=xlNormal, Password:= _ "", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:= _ False Appreciate ur help!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rename file based on current date
ActiveWorkbook.SaveAs Filename:= "C:\qadzidr\My Documents\" &
Format(Date,"ddmmmyy") & "am.xls" -- HTH Bob Phillips "wira" wrote in message ... Hi guys, I want to rename excel file based on current date and i would prefer the format as "ddmmyy". Here is part of the coding: ActiveWorkbook.SaveAs Filename:= "C:\qadzidr\My Documents\29Apr05am.xls" _ , FileFormat:=xlNormal, Password:= _ "", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:= _ False Appreciate ur help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Year-to-date based on current month | Excel Discussion (Misc queries) | |||
| to-date total based on current date | Excel Worksheet Functions | |||
| Current date formula based on month | Excel Discussion (Misc queries) | |||
| get back to day one based on current date | Excel Worksheet Functions | |||
| sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
Linear Mode
