[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

paulfound

@dvdfrck I think I know the issue.

Its a bit of a messy fix, but it should work.

1. Drop in a dynamic input. 

2. Type into the template source to %temp%test.csv and click ok. 

Notice that this is set to a CSV file:

3. Make sure your able to view xml properties:

If you cant' go to user settings and enable it.

4. Once enabled click on the dynamic tool and view xml

5. You should see this:

or something similar.

6. In the top right click edit and change the FileFormat from "0" to "-1"

if you click back onto the dynamic input and click edit you'll see that format is blank:

And that's it. as long as the outputs have the same number of columns it will work.