| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save a File with a cell value
Put
"C:\REPORTS\" & Range("A1").Value & Replace(Date, ".", "") & ".xls" in place of the filename! Substitute "A1" with the cell reference you want to get the name from! Regards, Stefi €˛Jonathan€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save a File with a cell value
simpler to use Format for date, no international issues then, and better to
format as yyyymmdd for sorting purposes Format(Date, "yyyymmdd") -- HTH Bob Phillips "Stefi" wrote in message ... Put "C:\REPORTS\" & Range("A1").Value & Replace(Date, ".", "") & ".xls" in place of the filename! Substitute "A1" with the cell reference you want to get the name from! Regards, Stefi "Jonathan" ezt ķrta: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save a File with a cell value
Yeees, I forgot that I have a specific default date format with "."s!
Stefi €˛Bob Phillips€¯ ezt Ć*rta: simpler to use Format for date, no international issues then, and better to format as yyyymmdd for sorting purposes Format(Date, "yyyymmdd") -- HTH Bob Phillips "Stefi" wrote in message ... Put "C:\REPORTS\" & Range("A1").Value & Replace(Date, ".", "") & ".xls" in place of the filename! Substitute "A1" with the cell reference you want to get the name from! Regards, Stefi "Jonathan" ezt Ć*rta: 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 |
| Reply |
| 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 | |||
Linear Mode
