Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save or open file as YYYYMMDD in Macros, how to record it
In Macros, I would like to save or open file name as YYYYMMDD or pickup name
from a cell where date is mentioned as =today() with format as YYYYMMDD. or any other alternative to pick up the file with naming convention as mentioned above. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save or open file as YYYYMMDD in Macros, how to record it
Activeworkbook.saveas filename:=format(date,"yyyymmdd") & ".xls", _
fileformat:=xlworkbooknormal Is one way to save a workbook with today's date. I didn't give it a folder location--so it'll save to the current folder (whatever that might be!). dim wkbk as workbook set wkbk = workbooks.open(filename:=format(date,"yyyymmdd") & ".xls") would be a way to open a workbook in the current folder that has today's date as the name. Vijay Kotian wrote: In Macros, I would like to save or open file name as YYYYMMDD or pickup name from a cell where date is mentioned as =today() with format as YYYYMMDD. or any other alternative to pick up the file with naming convention as mentioned above. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not open excel file xls. extensions | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Can't open a file and save under a different name | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel |