How to save Excel, using macro which takes the name from a cell contained in it?
How to save Excel as, using a macro which takes the name from a cell
contained in it?
Actually based on one of the postings here I can see that the following
script does the job.
ActiveWorkbook.SaveAs Filename:=Range("A1").Value
However I am wondering:
1- How can the path (directory/folder) can be incorporated in the
above?
2- How the above script can be executed automatically as soon as a name
is entered in the
"A1" cell for instance? Or even being saved after a specific time or
even conditional to an
other action?
Many thanks for your kind advice.
Cheers,
Reza.
|