| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save a File with a cell value
I have set my Excel file to save to a aprticular location, however I want to
be able to have the filename made up from the value in a worksheet cell i.e. Currently I have ChDir "C:\REPORTS" ActiveWorkbook.SaveAs Filename:="C:\REPORTS\mailinglist.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False I want where the file name is mailinglist.xsl to be populated by a value from a cell i.e. colleges21092005.xls (cellvalue+currentdate+filetype) Any pointers would be greatly appreciated! Tia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File save as cell value | Excel Discussion (Misc queries) | |||
| Autoname a save as file from a cell in a read only file | Excel Discussion (Misc queries) | |||
| Save file with cell name | New Users to Excel | |||
| Save a new file with the name that is in cell "C7" | Excel Discussion (Misc queries) | |||
| Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Threaded Mode
