T
Tomek
Does any one know if it is possible to use INDIRECT function to get a range
from another workbook?
Tomek P.
from another workbook?
Tomek P.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Yes, but not if it is closed unfortunately.
A
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"
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"
H
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]
T
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.
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.
H
Harlan Grove
...
...
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?
...
...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?