naming a workbook the same as a cell entry

D

des-sa

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Is this possible? 0
Office365 Family + TXT or MX Domain 0
Recover Outlook calendar entry 1
Excel Property is showing as Book not Workbook 0
How do I link a cell in a workbook? 1
selecting workbook/sheet 3
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0

Top