Open all files in a specific folder

[saachitalwar]

Hi,

I have a folder with various files and they all have 2-3 sheets each. How can I open all the files and get all the sheets?

I need to convert the .xls format files to .xlsx format essentially.

[binuacs]

@saachitalwar use batch macro, sample workflow attached

[saachitalwar]

I's afraid I haven't worked with batch macros before.

It's giving this error. How to add my folder?

[binuacs]

@saachitalwar are you trying to read .xls files?

[saachitalwar]

Yes, multiple files with sheet name either ABC/abc/ABCD

[binuacs · Accepted solution]

@saachitalwar inside the macro can you change the path .xls , save the macro and run again

[saachitalwar]

I changed it to xls and need help with the list of sheet names. this error is popping up

[binuacs]

@saachitalwar are you able to see the below option in your input file after connecting the .xls file

[saachitalwar]

I'm using a directory.

Do you mean dynamic input?

[binuacs]

@saachitalwar open a new workflow and connect any .xls file using input file and test the above settings