The Best Web Host!!

Open a workbook with a filename\location that is configured from another cell value

Open a workbook with a filename\location that is configured from another cell value:

ChDir “C:\Users\user_name\folder_one\folder_two”
Workbooks.Open Filename:= _”C:\Users\user_name\folder_name\Part_of_file_name1″ & variable & “.xls”