Hi,
I am trying to create a macro, which takes a 1x1 table with any filepath of any .xlsm file as an input and gives me the data form that file as an output.
Later I will have multiple Folders which all contain 3 .xlsm sheets. the workflow will be saved in every folder an is going to be used only once in every Folder. Thats why I want a really dynamic implementation without adjustments for every Folder. With the directory tool (.\ and *.xlsm*) I get all the file paths and with that I want to get the data behind the paths. I mean it must be possible somhow to get the data from the file with "only" the filepath. But I dont know how and I am running out of approaches.
Thanks for your help in advance!
Greetings, David
Solved! Go to Solution.
Hi PaulFound,
it is still the same error message. Do you have another idea?
the filed should be fullpath. the name of the field that has your full path.
Thanks! now it works :))