Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to include the contents of a cell in a filename
How do I include the contents of a cell containing the date (which is
automatically updated) in the file name? Hope I've asked clearly enough. Thank you, Leonard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to include the contents of a cell in a filename
Leonard, see if something like this will help,
MyName = "My Sheet For " & Format(Range("A1"), "mm.dd.yyyy") & ".xls" ActiveWorkbook.SaveAs Filename:=MyName -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "BARGAIN BIN" wrote in message ... How do I include the contents of a cell containing the date (which is automatically updated) in the file name? Hope I've asked clearly enough. Thank you, Leonard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Cell Contents Filename | Excel Worksheet Functions | |||
Macro to include contents of cell | Excel Discussion (Misc queries) | |||
Update - Include cell contents in filename automatically | Excel Programming | |||
Automatically include contents of a cell in "Save As..." filename. | Excel Programming | |||
cell contents as filename | Excel Programming |