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

's Computer Specifications

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

How would the criteria work?
--
Please contact me by email if you have an answer to this question. I
appreciate it.

's Computer Specifications

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")

"TAD from DBL" wrote:

> Is it possible to use an array formula to query an excel source data table?
>
> How would the criteria work?
> --
> Please contact me by email if you have an answer to this question. I
> appreciate it.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multi-Table query data source won't allow edits in Form	Tom Mackay	Microsoft Access Forms	7	22nd Sep 2009 10:56 PM
Query multiple data from source table	Raven	Microsoft Access Queries	2	13th Nov 2008 03:25 PM
how to make my custom formula in OLAP data source pivot table?	=?Utf-8?B?QWJvYmFrcl9OYXNy?=	Microsoft Excel Programming	0	19th Feb 2006 10:56 AM
I need to change the data source on a report from table to query	Nate	Microsoft Access	2	21st Mar 2005 04:41 PM
Need Formula to display pivot table source data	Don S	Microsoft Excel Worksheet Functions	3	23rd Feb 2005 10:13 PM