Saving a file with a cell name

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

Guest

Hi,
Im trying to make a template file that will be sent to several people to
fill in. They will have to select some information and I want them to save
the file with the name specified by the selection in certain cells, that will
give a name for each of them. How do I make the template ready for them just
to save it without modifying the name it should take?

Thanks a lot
 
Put a commandbutton or drawing object with a macro that runs code like this:

ThisWorkbook.SaveAs "C:\Excel\" & Worksheets("Sheet1").Range("A1").Value & ".xls", xlNormal

Of course, you need to change the path and which cell's value is picked up for the name.

HTH,
Bernie
MS Excel MVP


"Save a file with the name from a cell" <Save a file with the name from a
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top