Forum Discussion
Referencing a Closed Workbook using a cell value as the workbook name.
I need to reference specific cells in a bunch of closed workbooks.
Example: ='C:\Users\UserA\Workbooks\[WorkbookA.xlsx]Sheet1'!E13
Typing the workbook names for every reference is clearly a waste of time. How can I call in the workbook name into the reference formula from a list of names that resides in the same sheet as the reference formula. In the example above my thinking is to replace WorkbookA with a cell reference like A2 or A15 from within the same sheet. All of my attempts have failed.
1 Reply
I didn't read carefully but perhaps here https://stackoverflow.com/questions/28461672/referencing-value-in-a-closed-excel-workbook-using-indirect is some workaround. Simply using INDIRECT() doesn't work with closed workbooks.
