Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining Excel & ADODB.Recordsets

Status
Not open for further replies.
martync

martync

Programmer
Mar 4, 2002
7
AU
I currently run a SQL query on an adodb recordset and return the data to an excel spreadsheet.
What I would like to know is how I could enable the user to enter parameters into one of the excel worksheets and then suck this information into my adodb query?
Writing the code to handle the action events is no problem but I haven't got a clue how to get the data from excel into the SELECT statement before opening the ADODB connection.
Any ideas?
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
566
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
338
huiettcm
huiettcm
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
1K
dhookom
dhookom
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
297
mikrom
mikrom
office365
  • Locked
  • Question
app visual basic excel
Replies
4
Views
164
office365
office365

Part and Inventory Search

Sponsor

Back
Top