Error with batch macro in (.xls) files

Hi,

I have multiple excel workbooks in .xls type excel. I have set up a batch macro in auto configuration by position. It is working for some .xls files but for some it is giving me error.

Can you please look at it and help me know the reason why it is happening and how I can resolve it ?

Input

Macros

Batch Macro

Engine

Accepted answers

Rahul_Analyst

Hi all,

let me conclude it as a solution which worked. And, it was possible with the help of @gabrielvilella @RolandSchubert , thank you so much for the help.

.xls file can be changed manually to .xlsx files
The path in directory should be short. It should not be long.

Thank you.

All comments

gabrielvilella

You need this driver: JET Driver Error

Rahul_Analyst

Hi,

If I download this driver, my current 2019 version will not be working in my system. ( is it so ?)

Is there any solution which can help me get the outcome with current deriver ?

I tried to change excel file type to (.xlsx) then use this macro but then getting different error.

gabrielvilella

The driver is required to read old XLS files. It will not affect XLSX files. Changing the file extension manually will not work.

Rahul_Analyst

@gabrielvilella Thanks a lot!

If this driver is needed, then without having this driver, Alteryx is giving me output (doing union for 7 .xls files) for rest of the files (25 .xls files) not working.

Just curious to know, how it is working for 7 files. It should not work for even single file.

Felipe_Ribeir0

Hi @Rahul_Analyst . Just to share with you, i had the same problem and in my case, the input of .xls files was recurrent, so it would be a problem to change manually from .xls to .xlsx. So i built this macro that uses python to convert .xls into .xlsx and uses the xlsx as input.

Convert .xls into .xlsx and parse the input - Alteryx Community

Hope that this is useful for you!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235