Microsoft Query - Set .Name Range with Scope = Workbook in the QueryTables.Add command

[trizzo]

Hello, I would like to have the .Name (which is created automatically in Name Manager) with QueryTables.Add command to have scope = Workbook, the way it is creating on below code it is Sheet scope (Local) only. This way, I am unable to reference this .Name created in a Pivot Table.

Here is the code I am using:

Please Login or Register  to view this content.

So, in the above code the .Name is set in Name Manager is created with

Please Login or Register  to view this content.

Can anyone help me, please?

Thanks!!

[trizzo]

Thanks guys! I found an workaround!