Query Tables in Excel

[oafc0000]

Hey People

Im trying to automate the setting up of Query Tables within Excel via a VB.NET application.

I keep getting a "The parameter is incorrect" meesage on the following line of code.

wsXL.QueryTables.Add(SqlCon, QueryRange, "Select * From Call")

The full program is as follows

Dim objXL As New Excel.Application()
Dim wsXL As New Excel.Worksheet()
Dim QueryRange As Excel.Range

objXL.Workbooks.Add()
wsXL = objXL.ActiveSheet
QueryRange = wsXL.Range("A1")
wsXL.QueryTables.Add(SqlCon, QueryRange, "Select * From Call")

Can anyone help??

 

[Robby]

I have never used QueryTables...
Im not sure but your range may need to be something like this...
("A1:E10")