Hi,
Greetings !
I have multiple files ( up to 20 xls format file ) and I use Directory tool to upload all files, then filter require file :
The result show as below (which is correct) :
However, i have difficulties to use dynamic input tool, since all above file contain multiple tabs on each files.
I would like to input data from 'Sheet1' tab from each related files.
Kindly find dummy files as per attached.
Thank you in advance !
Solved! Go to Solution.
Hi @Qiu ,
Thank you for you sugesstion.
It is definitely a great macro tool to read xls and specific sheet.
However, since i already have existing directory tool which link to another workflow,
do you know how to combine filter tool ( yellow highlighted ) with the Macro tool ?
@fikrizahari You don't need to use a separate directory tool for this macro, all options available in this macro, check the Folder and Options tab in the macro
@fikrizahari
I am sorry if I misunderstand your question.
but do you mean something like this?
Or you want to stick to your directory tool?
Right.
I just realized that we can not really import the Sheet List for XLS files.
So using above Macro might the only choise we have.
Hi @binuacs,
As per my first posting, there's much more different files that require different preparation and massaging.
So, I already have existing workflow which start with Directory tool, however i find difficulties on filtering 'specific' tabs for xls file type.
Currently i was able to figure out how to connect with the 'Excel File Opener' macro tool with some changes on that macro.
Below is my current workflow :
Hi @Qiu,
I would like to combine the existing filter tool with the new 'Excel File Opener' macro tool.
As per mentioned above, below is the changes I have done on the macro to suit my requirement :
The existing tool on the 'Excel File Opener' macro tool :
My version of the 'Excel File Opener' macro tool :
Hence I was able to link the macro tool with my existing Filter tool
Hope its clarify !
Thank you once again !
@fikrizahari
good to know it works for you.
Thanks for the feedback!
It is not working. i am trying to import multiple excel file from the same folder with same header.