can I use an array formula to query a source data table?

T

TAD from DBL

Is it possible to use an array formula to query an excel source data table?

How would the criteria work?
 
J

Joel

I'm not sure but instead you can open the access opbject to get the data.

Set obj = CreateObject("Access.application")
obj.Visible = True
Set myDB = obj.Open(Filename:="c:\temp\myDB.mdb")
 
Top