Workflow

[anupgupta12]

Does somebody know if Alteryx can read macro enabled excel worksheet?

[atcodedog05]

Hi @anupgupta12 

I guess it will read only the displayed data. If you have a excel with macro you can try it out.

[anupgupta12]

I think, it does not read, when we try to bring macro enabled file through input tool, this file doesn't show up in folder for Alteryx to read.

[atcodedog05]

Hi @anupgupta12 

What's the extension of the file

[anupgupta12]

So basically, I was trying to get output to a macro enabled file, but I couldn't do that.

[anupgupta12]

.xlsm

[atcodedog05]

Hi @anupgupta12 

It should be possible.  Do you have Access db driver 2010 installed. If not you, you need to have it installed maybe then you can read the file.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Importing-data-from-xlsm-format/td-p/6... 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-input-xlsb-files/td-p/555604 

Hope this helps 🙂