Open a workbook with a filenamelocation that is configured from another cell value:

ChDir “C:Usersuser_namefolder_onefolder_two”
Workbooks.Open Filename:= _”C:Usersuser_namefolder_namePart_of_file_name1″ & variable & “.xls”