Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Create a QueryTable from an Excel Source in VBA

Create a QueryTable from an Excel Source in VBA

Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2008/06/24/create-a-querytable-from-an-excel-source-in-vba/

Posted Jun 24 2008, 09:03 PM by Daily Dose of Excel
Filed under: ,
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.