Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

dvdfrck
7 - Meteor

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

12 REPLIES 12
dvdfrck
7 - Meteor

Hi PaulFound,

 

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

paulfound
11 - Bolide

PaulFound_0-1598530894851.png

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

dvdfrck
7 - Meteor

Thanks! now it works :))

Labels