| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use an array formula to query a source data table?
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Source for MS Query | Excel Discussion (Misc queries) | |||
| how to make my custom formula in OLAP data source pivot table? | Excel Programming | |||
| how to lookup one source with alot of table array? | Excel Programming | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Threaded Mode
