Thread: naming a workbook the same as a cell entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adilson Soledade Adilson Soledade is offline
external usenet poster
  
Posts: 19
Default naming a workbook the same as a cell entry
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)

--
Adilson Soledade


"des-sa" wrote:

is it possible to automatically name a workbook the same as a cell entry when
i instruct the program to save the file?
Reply With QuoteReply With Quote