Fx: INDIRECT to external workbook

[Tomek]

Does any one know if it is possible to use INDIRECT function to get a range
from another workbook?

Tomek P.

 

[Ken Wright]

Yes, but not if it is closed unfortunately.

 

[Andy Wiggins]

As an alternative to INDIRECT you might consider SQL.REQUEST.
This file shows how to use it:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"

 

[Harlan Grove]

Does any one know if it is possible to use INDIRECT function to get a range
from another workbook?

Caveat with respect to using SQL.REQUEST: your data would need to be organized
as a table with field names in the top row.

Other alternatives may be found in the article referred to in the following
link/url.

http://www.google.com/[email protected]

 

[Tomek]

Thanks for you prompt response.
The method described in the article using SUMPRODUCT doesn't seem to be
working in my case. The problem is that my other worksheet contains string
data.

 

[Harlan Grove]

...
...

The method described in the article using SUMPRODUCT doesn't seem to be
working in my case. The problem is that my other worksheet contains string
data.

...

The SUMPRODUCT in the linked article only pertained to that thread's particular
subject. The methods for accessing data from other *closed* workbooks may be
applicable to your needs, and is independent of SUMPRODUCT.

What are you trying to do? What do your formulas look like?