Referencing Named Ranges and Tables in SQL Queries with VBA

Overcoming Internal Name Issues in SharePoint Integration with Excel via ADO Connection