Variable Filename
 

Hi Guys,

In an Excel Macro I want to use a command to save an active Excel file in
folder C:\2009 and the name of the file should be 7A €˜space and then the
contents of cell B3 of the active file.
Example: 7A Garo (Garo is the contents of cell B3)

In another macro I want to open this same file keeping the 7A constant but
the rest of the filename is the contents of a cell C3 of the active file.

Thanks

Variable Filename
 

Workbooks.SaveAs "7A " & Activesheet.Range("B3").Value

and

Workbooks.Open"7A " & Activesheet.Range("C3").Value

--
__________________________________
HTH

Bob

"Berj" wrote in message
...
Hi Guys,

In an Excel Macro I want to use a command to save an active Excel file in
folder C:\2009 and the name of the file should be 7A 'space' and then the
contents of cell B3 of the active file.
Example: 7A Garo (Garo is the contents of cell B3)

In another macro I want to open this same file keeping the 7A constant but
the rest of the filename is the contents of a cell C3 of the active file.

Thanks