How do I use the contents of a cell to automatically name a file using a macro to populate Save As?
R Rob Nov 22, 2004 #1 How do I use the contents of a cell to automatically name a file using a macro to populate Save As?
T tjtjjtjt Nov 22, 2004 #2 Include this in your macro: Activeworkbook.SaveAs Filenmae:=Range("A1").Value & ".xls" tj
