Activeworkbook.SAveAs Filename = Worksheets("Sheet1").Range("A1")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"ynissel" wrote in message
...
whats the syntax to save a file in a macro but use the file from within a
cell
i.e. if cell A1 is the name I want to save the file as - how do I
reference
that cell from within the macro?