Variable File Naming Using Macros

Is there a way to open a file and rename it using cells within the document
itself using a macro? (Variable File Name?)

Also, is there a way to open a file, using a macro again, by using criteria
on a cell in an open worksheet? (Variable File Call?)

Hi
yes you can do this. e.g.
sub save_it()
with activesheet.range("A1")
activeworkbook.saveas filename:= "C:\temp\" & .value & ".xls"
end with
end sub


Similar with opening workbooks. See workbooks.open in the vBA help




--
Regards
Frank Kabel
Frankfurt, Germany


Kris S wrote:
Is there a way to open a file and rename it using cells within the
document itself using a macro? (Variable File Name?)

Also, is there a way to open a file, using a macro again, by using
criteria on a cell in an open worksheet? (Variable File Call?)