MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I pass a variable from Excel to a MSQuery condition?


Posted by Stephen Maher on September 25, 2001 4:54 PM

When using MSQuery to retrieve data from Access or other data sources I often wish I could pass part of the SQL in the query from the sheet from where the query is refreshed. Is this possible?


Posted by lenze on September 27, 2001 5:37 AM

I'm not sure what you're asking, but you can set a parameter which is linked to a cell on your worksheet.