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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top