Hi All,
So after reading some posts it seems I would need to use the Indirect function for the following scenario:
1. on a daily basis as a result of an automation I have a folder generated with files generated with partly static name e.g. "Workbook" and partly dynamic file name e.g. TimeStamp
2. In one of the files I need to do a vlookup to retrieve a value from another CLOSED workbook (I do not want to be opening and closing this workbook as it is heavy)
3. The sheet where I need to retrieve the vlookup values will always have a static name e.g. "Sheet6"
3. The files (the one where I want to use Vlookup and the file to retrieve from) will always be in the same folder every time, but I also have other (excel) files in that folder
How can I reference to the closed "Workbook-DynamicName" sheet 6?
Thanks a lot
So after reading some posts it seems I would need to use the Indirect function for the following scenario:
1. on a daily basis as a result of an automation I have a folder generated with files generated with partly static name e.g. "Workbook" and partly dynamic file name e.g. TimeStamp
2. In one of the files I need to do a vlookup to retrieve a value from another CLOSED workbook (I do not want to be opening and closing this workbook as it is heavy)
3. The sheet where I need to retrieve the vlookup values will always have a static name e.g. "Sheet6"
3. The files (the one where I want to use Vlookup and the file to retrieve from) will always be in the same folder every time, but I also have other (excel) files in that folder
How can I reference to the closed "Workbook-DynamicName" sheet 6?
Thanks a lot
