Hello, I have some code that works to pull all files from a server location specified within the code.
I would like to slightly change this data to pull the path from a cell reference (sheet1 cell A1) instead of within the code.
When I run the code, nothing happens. I run the alternate code with the path in the coding, it works just fine.
Reason being, several ppl work with this data and would like them to update a cell instead of changing a line of code monthly.
Any help would be appreciated (btw: only pulling files in a folder starting with the work Comparative)
Bookmarks