Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save or open file as YYYYMMDD in Macros
In Macros, How is it possible to record for a file name as YYYYMMDD to open
or save file names. Please inform me if possible with any other alternatives to save or open files with similar naming convention in Macros. OR to pick up name of the file from any cell where today() is mentioned |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save or open file as YYYYMMDD in Macros
Activeworkbook.SaveAs Filename:=Format(Date,"yyyymmdd")
as a starter -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Vijay Kotian" wrote in message ... In Macros, How is it possible to record for a file name as YYYYMMDD to open or save file names. Please inform me if possible with any other alternatives to save or open files with similar naming convention in Macros. OR to pick up name of the file from any cell where today() is mentioned |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save to same file as opened | Excel Discussion (Misc queries) | |||
Can not open excel file xls. extensions | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
How save a lotus 2.2 file in excel and to open it in excel and pe. | New Users to Excel |