Hi,
I have a macro to consolidate .xlsb files residing in a folder. Lets say there are two files, my current macro is iterating two times but loading the first file itself two times. Please help. Thanks in advance.
Solved! Go to Solution.
Hi,
can you try to use a formula to create the full syntax expected by the action in the macro to replace the full file name: path + filename + ||| + datasheetname and try it.
Here is the syntax:
Thanks you so much !! It worked !