ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving a file with a name from a cell value. (https://www.excelbanter.com/excel-programming/289578-re-saving-file-name-cell-value.html)

arno

Saving a file with a name from a cell value.
 
Hi,


I need to write a macro that when executed, will save a file with the name

taken from the value of a specific cell in that spreadsheet.

you should have a cell named "myName" to make this line work:

ActiveWorkbook.SaveAs Filename:=Range("myName").Value

bye

arno




All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com