cell contents as filename

  • Thread starter Thread starter Jeff R
  • Start date Start date
J

Jeff R

I have a form that I save under a new filename each time
it is filled out. I would like to record a macro that
saves the file with a name that represents the text in a
certain cell.
Example: Cell A1 contains the name of a customer/job,
lets say Smith22. I would like a macro to automatically
save the file with a filename of Smith22.xls.
The macro would be assigned to a button next to the cell.
Is this possible?
Thanks!
Jeff R
 
Application.DisplayAlerts = False
thisworkbook.SaveAs ThisWorkbook.Path & "\" & _
ThisWorkbook.Worksheets("Sheet1").Range("A1").Value & _
".xls"
Application.DisplayAlerts = True
 
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

Referencing a cell value in a macro 7
Cell reference to determine filename 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Save a pdf to the desktop with a filename as a cell reference 2
Save As Part 2 2
Set initial filename before saving 4
save file as different name until cell is blank 4
SaveAs Macro - Build filename from cell contents HOW? 4

Back
Top