Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save a new file with the name that is in cell "C7"
Here is what I want to do:
Open up a template. Enter information. Click on save, and when the window shows up asking me to name the file, I want it to automatically use a file name with the value in cell C7. As an example, if cell C7 has "Milton 287-12", I want to automatically name the file"Milton 287-12" when I save for the first time. Is this possible? Thanks, Joe |
#2
|
|||
|
|||
Hi, Lunker,
Try pasting the following code into a macro sheet and running it with Alt-F8 Change the path to whatever you require between the quote in line 3 and "A1" to whatever cell you want to use to contain the filename. Have a good weekend Pete Sub SaveAsCellString() ActiveWorkbook.SaveAs Filename:= _ "D:\" & Range("A1").Formula, FileFormat:=xlExcel9795, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub "lunker55" wrote: Here is what I want to do: Open up a template. Enter information. Click on save, and when the window shows up asking me to name the file, I want it to automatically use a file name with the value in cell C7. As an example, if cell C7 has "Milton 287-12", I want to automatically name the file"Milton 287-12" when I save for the first time. Is this possible? Thanks, Joe |
#3
|
|||
|
|||
Works perfectly!!
Thank you very much Peter. Joe "lunker55" wrote in message .. . Here is what I want to do: Open up a template. Enter information. Click on save, and when the window shows up asking me to name the file, I want it to automatically use a file name with the value in cell C7. As an example, if cell C7 has "Milton 287-12", I want to automatically name the file"Milton 287-12" when I save for the first time. Is this possible? Thanks, Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Automatically save file based on cell value | Excel Discussion (Misc queries) | |||
Click on X in upper right corner should save FIRST the file you se | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |