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