[Urgent] Macro that gives back the data from any filepath

[dvdfrck]

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

[dvdfrck]

Hi PaulFound,

it is still the same error message. Do you have another idea?

[paulfound]

the filed should be fullpath. the name of the field that has your full path.

[dvdfrck]

Thanks! now it works :))