Hi all,
I am having problems with a relative (as opposed to an absolute) folder path.
I am trying to reach out to a folder called "Forms to upload" that is in the same folder as the workbook that contains the macro, and then loop through all the files in the folder "Forms to upload", copy and pasting from sheet "Agency Background" (same sheet appears in all the files) into a master sheet "tbl_AGBACK1" in the current workbook.
I nicked this code from a previous thread:
The problem is the code gets stuck at the line:
And I think the problem is I have the syntax wrong of this relative file path:
Hope someone can help.
Thanks
Henry
Bookmarks