Add Macro input tool in WF

Question

Hello,

I have multiple input files with the same structure, so I decided to use a Dynamic Input Tool. However I got this error back: "[Filename] does not match a sheet or named range in [in the folder]".

So, do you think a macro input tool would do the job without any issues?

If yes, can you help setup this tool?

Thank you.

afv2688 · Answer

Hello @beatrizmguerreiro,

This is a typical error you can get when the files you are trying to merge together have some differences in the filename. To me more specific, this error "tends" to happen when you try to merge together several excel files with a fixed sheet name but by some reason, the sheetname in one of them is different. Could this be your case? Knowing what kind of files you are trying to merge would help with setting up an example.

Regards

messi007 · Answer

@beatrizmguerreiro,

The dynamic read will do the job, you have to add the sheet name before the input.

Attached the workflow,

Hope this helps,

Regards,

ReadFiles20210216.yxmd

AngelosPachis · Answer

Hi @beatrizmguerreiro ,

Before resorting to the batch macro solution, let's see if we can solve it with the Dynamic input tool. Do the different files have the same sheet name?

If yes, probably the error you are getting is because the sheet name is not included in the Full path. I assume you have used a directory tool to read the location of all those files, but then if you pay attention to the full path column, you will see that the information for Sheet is missing.

You can use a formula tool to add that to the Fullpath column (again if your files have the same sheet names)

Let us know if that worked or you need further support on the macro.

Cheers,

Angelos