QueryTable Lookup

A

Andy

I am trying to populate Excel comboboxes (or something similar) from data in
Access. By scouring the internet, I found out about QueryTable and I have
written code that will return the results of a query onto an Excel sheet. I
would like the results to go to comboboxes. Here is what I have:

Set varQuery = ActiveSheet.QueryTables.Add(Connection:=varConn,
Destination:=Range("a1"), Sql:=varSql)
varQuery.Refresh

Any help is appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference a VBA Query from Access 4
SQL ODBC Connection 0
data disappear after extracting from querytable 0
UPDATE through a QueryTable? Or? 0
How to obtain the row count of a QueryTable from a Web query 4
QueryTables, some basic questions 5
excel dates in sql procedures 2
QueryTable connection using ADO Recordset 3

Top