Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell contents as filename
I have a form that I save under a new filename each time
it is filled out. I would like to record a macro that saves the file with a name that represents the text in a certain cell. Example: Cell A1 contains the name of a customer/job, lets say Smith22. I would like a macro to automatically save the file with a filename of Smith22.xls. The macro would be assigned to a button next to the cell. Is this possible? Thanks! Jeff R |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell contents as filename
Application.DisplayAlerts = False
thisworkbook.SaveAs ThisWorkbook.Path & "\" & _ ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e & _ ".xls" Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Jeff R" wrote in message ... I have a form that I save under a new filename each time it is filled out. I would like to record a macro that saves the file with a name that represents the text in a certain cell. Example: Cell A1 contains the name of a customer/job, lets say Smith22. I would like a macro to automatically save the file with a filename of Smith22.xls. The macro would be assigned to a button next to the cell. Is this possible? Thanks! Jeff R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create filename based on cell contents | Excel Worksheet Functions | |||
Vlookup Cell Contents Filename | Excel Worksheet Functions | |||
Cell Contents to identify source Filename | Excel Discussion (Misc queries) | |||
Multiple If's, one variable. And filename as cell contents | Excel Programming | |||
Multiple If's, one variable. And filename as cell contents | Excel Programming |