Forum Discussion
Solved
Variable workbook name in a formula “indirect”
Dears, I have been trying to find a solution to get some data from different excel workbooks without the need to have them opened. I tried the indirect function, but it doesn’t work. Also, index func...
AldighaithirMM sure. Code is in 'Extract Test.xlsm'. Values are from 'Test.xlsx'. Change variables to suit.
Thank you very much Zack for the quick reply
Would you mind attaching an example file so i can relate to when trying to change the code to fit my requirements?
Would you mind attaching an example file so i can relate to when trying to change the code to fit my requirements?
AldighaithirMM sure. Code is in 'Extract Test.xlsm'. Values are from 'Test.xlsx'. Change variables to suit.