filename in macro
Activeworkbook.SAveAs Filename = Worksheets("backup").Range("A15")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"ynissel" wrote in message
...
this is great - thanks! what would the syntax be if the range I want to
name
is in a sheet called backup and the cell is A15?
Thanks again.
"Gary''s Student" wrote:
Let's put qwerty.xls in cell A1. Then:
Sub Macro1()
ChDir "C:\"
ActiveWorkbook.SaveAs Filename:="C:\" & Cells(1, 1).Value
End Sub
will do a save_as to your top-level directory.
--
Gary''s Student
"ynissel" wrote:
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?
|