saving with name from cell

J

jamaz

Hi all.

I'm trying to place the contents of a cell (or two) into the save a
name when saving a workbook.

Anyone know of a simple way to accomplish this?

Thanks
 
R

Ron de Bruin

You can use this jamaz

ActiveWorkbook.SaveAs Sheets("mysheet").Range("d1").Value & ".xls"

Or

ActiveWorkbook.SaveAs Sheets("mysheet").Range("d1").Value _
& Sheets("mysheet").Range("A1").Value & ".xls"
 
Top