This macro will read xls, xlsx, xlsb and xlsm file types from a folder. I created this in 2015 while I worked at Alteryx and am just moving it over now that the old gallery is gone. See the original community article for more details.
Error: Record #1: SheetReader (77): Record #1: Tool #1: The 2017-10-10 Windows security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver
Hi getting the following error : Excel File Opener (5) Tool #3: Record #2: Tool #26: The external program "..\SupportingFiles\unzip.exe" returned an error code: 9
@camerondsteele I'm new to Alteryx, but your macro really saved me a ton of time. However, I have excel sheets on a sharepoint site that I need to run this macro on, but your macro does not accept UNC for SharePoints. Any thoughts on how to remedy that?
Sorry for seeing this now. I took a different approach. I told my users to consolidate their excels into just one file with many tabs, so I was able to bring in all tabs and append them with little issues.
This was my work around....it may not work for you.
I test the workflow, it works perfectly on the old engine. However, I keep getting this error on the new Alteryx version (with AMP engine).
Error: Excel File Opener (66): Tool #5: Record #1: Tool #1: Set up a Connection to use the Tool Error: Excel File Opener (66): Tool #5: The output connection "Output" was not valid
Any chance you will make an update to solve this issue?
@JokeFun ...chances are that if they blocked the downloading of this tool from the Alteryx.com site, then they've probably blocked it from other sites. You should contact your IT Dept. to download it for you.
