Can I use a cell reference in an Excel worksheet as criteria to fi

J

Jasen

I want to use a cell reference from Excell to edit Access Database queries in
the same Excel file. I have fifteen seperate queries that will be changed on
a monthly basis and I would like to use one cell reference that can be
changed monthly instead of editing each individual query. Thanks.
 
M

Michel Walsh

Hi,


Not directly, but inside the query, you can refer to a user defined
function, written in VBA, inside an Access module of the db, that will
return the value of the Excel cell.



Hoping it may help,
Vanderghast, Access MVP
 
Top