| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save excel file with filename = cell text
Hi,
I'd like to add some code to the end of my macro that saves the current excel file with a filename derived from the text of two cells in the worksheet. ie: i4 = 5486, i3 = TB -- The filename would be 5486TB.xls What code do i need? Thank you for your help Regards Troy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save excel file with filename = cell text
ActiveWorkbook.SaveAs Range("I4") & Range("I3") & ".xls"
Of course, this assumes that (a) the current directory is the one that you want save the file into and (2) there is no file by the same name in the same location. So you will need some error-checking. -- Vasant "TroyB" wrote in message u... Hi, I'd like to add some code to the end of my macro that saves the current excel file with a filename derived from the text of two cells in the worksheet. ie: i4 = 5486, i3 = TB -- The filename would be 5486TB.xls What code do i need? Thank you for your help Regards Troy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to save file as different filename | Excel Worksheet Functions | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| Auto save file copy with unique filename | Excel Worksheet Functions | |||
| Save file as text from cell | Excel Discussion (Misc queries) | |||
| Save as .htm with filename from cell | Excel Discussion (Misc queries) | |||
![TroyB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
