D des-sa May 9, 2008 #1 is it possible to automatically name a workbook the same as a cell entry when i instruct the program to save the file?
is it possible to automatically name a workbook the same as a cell entry when i instruct the program to save the file?
A Adilson Soledade May 9, 2008 #2 If the name is, for example, at Range A1 in a Worksheet called Setup, you could use this command: ThisWorkbook.SaveAs (Worksheets("SetUp").Cells(1, 1).Value)
If the name is, for example, at Range A1 in a Worksheet called Setup, you could use this command: ThisWorkbook.SaveAs (Worksheets("SetUp").Cells(1, 1).Value)
