Thanks. I really like this solution. I followed it step by step and it worked like a charm. However, when I came back to re-use it in the following period, it gave me an error on the Mapping Table Marco saying that it can not open desktop.ini file in the folder with the detail files I am trying to combine. I revisited the entire process and everything is as it should be and how it worked the last time. It appears that the first step "Directory" is creating an extra file (according to the output, which is different than yours), so Mapping Table Marco is looking for it, but it is not in the folder. Will appreciate suggestions. Thanks
What is the difference between control parameter and folder browser and why have you used folder browser tool in the macro instead of control parameter?
When I created to directory macro, is telling me that I need the input for this batch macro but yours isn’t showing that. Is this true? if so, how can I fix it?
This is the only method that worked for me after trying out so many other videos...thanks!
This was the best tutorial ever !
yo if the is messing you up make sure the case is correct AND you're using the | key and not \
Followed each step and worked really well for me! Much appreciated!
Thanks. I really like this solution. I followed it step by step and it worked like a charm. However, when I came back to re-use it in the following period, it gave me an error on the Mapping Table Marco saying that it can not open desktop.ini file in the folder with the detail files I am trying to combine. I revisited the entire process and everything is as it should be and how it worked the last time. It appears that the first step "Directory" is creating an extra file (according to the output, which is different than yours), so Mapping Table Marco is looking for it, but it is not in the folder. Will appreciate suggestions. Thanks
What is the difference between control parameter and folder browser and why have you used folder browser tool in the macro instead of control parameter?
My excel files have multiple tabs also, and i want to combine only specific tab at a time
When I created to directory macro, is telling me that I need the input for this batch macro but yours isn’t showing that. Is this true? if so, how can I fix it?
getting error while insert mapping table and run
Could you solve it? I'm having the same error 😢
It doesn´t work for me, I´m sorry. It is messing up with mapping table and name
Same here ... I'm trying to understand but I have no clue.If someone has an idea, it would be greatly appreciated!
formules?