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

  • Thread starter Thread starter TAD from DBL
  • Start date Start date
T

TAD from DBL

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

How would the criteria work?
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
UDF in Excel 2007 for Filter or Query 2
vba array logic 3
VBA SQL - variable Source Data... 2
Can I use a UDF in an array formula? 2
Array Formula In IF Function 0
Excel-Query-Access Question 3
problem with array formula 5

Back
Top