Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Error opening an XLS (not xlsx) file

Highlighted
8 - Asteroid

@DanJones

your macro works like a charm!! Thank you so much for it. But when the.xls has more than one tab, only the first one is converted into csv. 

Was looking at the macros inside but couldn't work around how/where to change it in order to get as many csv's as .xls tabs, or merge them into one csv!

Regards,  

5 - Atom

This macro set is awesome! We receive 2003 excel files from business partners and I needed a way to convert them to the xlsx format! Do you have the ability to add to this and select a different location for the new files to be saved? I am currently seeing both the xls and xlsx versions in the folder. I would like to have all the newly written xlsx files in their own folder. Thanks! 

Highlighted
8 - Asteroid

@MarqueeCrew thank you for your solution.  It worked like a charm.  All I had to do was change

 

C:\Program Files (x86)\Microsoft Office\root\Office16\excelcnv.exe

 

to

 

C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe

 

It didn't give me any errors or anything AND it works for .xls files with multiple tabs.  THANK YOU SO MUCH!

Labels