Hello everyone!
I am trying to make a master workbook that will update itself from offline files that are in a specified working folder. I am using this code to grab the file names:
This code does the following: it look for all XLS files in the Data folder and lists them in Files.
However, I am stuck on the next part. I cannot find a way to use this retrieved data to link information from the offline files. If I use ='path[file.xls]worksheet'!range and replace it with cell names (A1, A2, etc) I get a #REF! error.
Is there a way to do this? I don't mind if its VB code or a formula. Any input will be greatly appreciated.
Thank you in advance,
Felipe
Bookmarks