This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am attempting to use the CREW wildcard macro to input a file with information in 23 tabs.
I am getting an error for three of my tabs from Tool #4 in the macro saying that "'tab name' does not match a sheet or named range in 'file path'". I am trying to figure out what about these three tabs is different from the others. I went to to the source of the error in the macro and ran then through individually, and they seemed to work.
Has anyone else ran into this error or know what could possibly be causing it?
CReW has 2 "Wildcard" macros: Wildcard Input & Wildcard XLSX Input. There is also a similar macro in the gallery "Read_all_Excel_Files" that I recommend. I looked at both of the macros from CReW and did not find a Tool #4. Please try another tool and if you've got more details to share, I'll try to take a look at this for you.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.