I have created a cell that has a varaible file name and I want to save the
file in a variable folder name (for which I have another cell with the new
info). The folder is \SURNAME, INITAL\ and the file name is FINANCE
SURNAME.xls. I open the master FINANCE file and I want to save it as
"C:\ACTIVE CLIENTS\SURNAME, INITIAL\FINANCE SURNAME.xls" The variables in
that path are "SURNAME" and "INITIAL".

How do I get VB to get the information from the cell and then save the new
variable name file? The cells are called folder_name and file_name

With Worksheets("Sheet1")
Activeworkbook.SaveAs Filename:= .Range("folder_name") &
..Range("file_name")
End With

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Brettjg" wrote in message
...
I have created a cell that has a varaible file name and I want to save the
file in a variable folder name (for which I have another cell with the new
info). The folder is \SURNAME, INITAL\ and the file name is FINANCE
SURNAME.xls. I open the master FINANCE file and I want to save it as
"C:\ACTIVE CLIENTS\SURNAME, INITIAL\FINANCE SURNAME.xls" The variables in
that path are "SURNAME" and "INITIAL".

How do I get VB to get the information from the cell and then save the new
variable name file? The cells are called folder_name and file_name

Thankyou so much Bob, you've changed my life!

"Bob Phillips" wrote:

With Worksheets("Sheet1")
Activeworkbook.SaveAs Filename:= .Range("folder_name") &
..Range("file_name")
End With

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Brettjg" wrote in message
...
I have created a cell that has a varaible file name and I want to save the
file in a variable folder name (for which I have another cell with the new
info). The folder is \SURNAME, INITAL\ and the file name is FINANCE
SURNAME.xls. I open the master FINANCE file and I want to save it as
"C:\ACTIVE CLIENTS\SURNAME, INITIAL\FINANCE SURNAME.xls" The variables in
that path are "SURNAME" and "INITIAL".

How do I get VB to get the information from the cell and then save the new
variable name file? The cells are called folder_name and file_name