(hmmm, I posted a message a few hours ago, but it doesn't seem to
have been posted, so I guess I'll try again...)

I would like to use Harlan Grove's PULL function to reference data in
a potentially-closed workbook. (I do not want to use direct links,
as I hope to be able to specify the spreadsheet name and directory in
a cell.)

Can the PULL function refer to a named range in the external
workbook? I have done many Google searches, and found a message from
Harlan that was possiblying impliying it could be done, but I
couldn't get it to work myself. I could only get PULL to work by
using an explicit range like Sheet1!A1:C3.

Thanks,
Shawn


--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

wrote...
....
Can the PULL function refer to a named range in the external
workbook? I have done many Google searches, and found a message from
Harlan that was possiblying impliying it could be done, but I
couldn't get it to work myself. I could only get PULL to work by
using an explicit range like Sheet1!A1:C3.
....

As currently written, it can only fetch scalar defined names, i.e.,
single values, not ranges or arrays. I also just found another bug.
Just after the line

If Left(b, 1) = "'" Then b = Mid(b, 2)

you need to add the statement

If Right(b, 1) = "'" Then b = Left(b, Len(b) - 1)

I'm working on pulling arrays and single area range defined names, but
you may want to consider using Laurent Longre's MOREFUNC.XLL add-in
instead, specifically, it's INDIRECT.EXT function.

Thanks Harlan.

I am hoping to be able to use your function, since that way the code can be a
part of the spreadsheet, and I won't be dependent on the other user having the
DLL...

Thanks again for your help.

Shawn
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

You can include Morefunc in the workbook, the new version has a setup file
where you can add a menu to the tools menu, in that menu there is an option
called "embed morefunc in the workbook"


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Shawn" wrote in message
...
Thanks Harlan.

I am hoping to be able to use your function, since that way the code can
be a
part of the spreadsheet, and I won't be dependent on the other user having
the
DLL...

Thanks again for your help.

Shawn
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------