Batch Macro to import multiple file having different schema

Question

Hi Everyone,

I am having a batch macro to import multiple excel files from a folder, having different schema. However, I am still not able to import all the files as they are being dropped even after using Batch Macro. Below is the screenshot of the same.

And below is the workflow which imports all the files and use it for further processing

Any help on this would be welcome, I am stuck in this place for a long time

Regards,

Deba

mbarone · Answer

Great, glad you figured it out!

Deba93 · Answer

Hey Thanks for the reply, I had made those changes in the beginning itself, however what I missed out was including the Sheet Name after the directory input. As I have mentioned above.

Deba93 · Answer

Hey Thanks for the reply, I had made those changes in the beginning itself, however what I missed out was including the Sheet Name after the directory input. That was the reason why records were being dropped