Does somebody know if Alteryx can read macro enabled excel worksheet?
Hi @anupgupta12
I guess it will read only the displayed data. If you have a excel with macro you can try it out.
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.
What's the extension of the file
So basically, I was trying to get output to a macro enabled file, but I couldn't do that.
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/6528
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-input-xlsb-files/td-p/555604
Hope this helps 🙂
