community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Input XLSB to XLSX Convert

Highlighted
Asteroid

Hey All,

 

I am in need of help creating a macro to be able to insert a Binary (XLSB) file and convert it to XLSX before performing the rest of the workflow. I understand there is an access driver but we are not allowed to download it for the client so the macro would be the only way for us to do a workaround. Anything would be very helpful. Thanks!!

Nebula
Nebula

Hi @chughes49 

 

You should be able to call an excel macro directly to perform the conversion for you.  Check out this thread.  The first example deals with converting a .xlsm to xlsx, but the concept should work for you as well.

 

Dan

Labels