Hi!
How do I reference a cell in another workbook, but have file name change dynamically. I've tried concatenating a string, but i keep getting a value error.
This is what I want to do:
where cellReference is:
Thanks for your help!
How do I reference a cell in another workbook, but have file name change dynamically. I've tried concatenating a string, but i keep getting a value error.
This is what I want to do:
Code:
cellReference&"Sheet1'!A1"
Code:
'C:\Data\[filename.xlsx]
Thanks for your help!