Macro not working

[TarunaT]

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.

[WilliamR · Accepted 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:

[TarunaT]

Thanks you so much !! It worked !