Is there any way of generating a "save as" file name from the contents of a cell? Jeff
J Jeff Granger Oct 4, 2006 #1 Is there any way of generating a "save as" file name from the contents of a cell? Jeff
B Bob Phillips Oct 4, 2006 #2 Activeworkbook.SaveAs Filename:=Range("A1").Value -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Activeworkbook.SaveAs Filename:=Range("A1").Value -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
