Import values from multiple defined Named Range from multiple sheets

[SidUK]

Hi,

I am looking to input data into Alteryx from an Excel which has multiple defined named ranges on multiple sheets. I want to use the defined name range to pull in the data.

I understand how it works when it's not defined (e.g. A1) then its Full path + '|' + SheetName$A1:A1'.

Using the link below I am able to pull down the list of the defined named ranges in the Excel...just don't know how to use it to pull the associated data

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-get-a-list-of-all-named-range...

Attach is a test file with the following defined named range.

CS_CompanyName

CS_CompanyAddress

CD_NoOfEmployees

CD_AnnualRevenue

Note, the actual live data source has 20+ defined named ranges

Any help/guidance much appreciated

[grossal]

Sorry for the delay. I checked my computers and realized that I have no computer left with 2019.3, therefore I just unpacked both and changed the version of both. You'll need to add the macro manually into the workflow. You can see the setting in the screenshot:

(ClientA.xlsx was the file that is used in the original macro input)

Let me know if this helps. I can also re-download and install 2019.3 tomorrow if it doesn't work.

Best

Alex