oafc0000 Posted March 25, 2003 Posted March 25, 2003 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?? Quote
Moderators Robby Posted March 25, 2003 Moderators Posted March 25, 2003 I have never used 'QueryTables'... I'm not sure but your range may need to be something like this... ("A1:E10") Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.