Saving a file with a cell name
 

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

Saving a file with a cell name
 

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
wrote in message
...
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