Automatically naming a file using cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use the contents of a cell to automatically name a file using a
macro to populate Save As?
 
Include this in your macro:
Activeworkbook.SaveAs Filenmae:=Range("A1").Value & ".xls"

tj
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VB Code Required 3
Save as a new format name automatically 2
Selecting all cells with content using a variable 3
Macro to clear contents of certain cells 4
Macro: finding a cell on one worksheet and copying to another worksheet 0
can i have do a running total for workbooks in a seperate workbook 1
How to save file in a macro taking new name from cell contents? 3

Back
Top