Generating File Names

[Barry]

Is there a way I can automatically generate a file name
using the contents of a cell. i would like the user to
be able to simply press Ctrl+s and save the file name as
a unique number generated in a cell.

Thanks

 

[Bob Phillips]

Barry,

Try something like

Activeworkbook.SaveAs Filename:= "C:\myTest\" & Range("A1").Value &
".xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)