I don't think it's a configuration problem. Harlan's UDF works fine for me.

I'd double check the values and the concatenated string--just to make sure there
is not typing mistake.

In fact, I'd create a simple file: "c:\test.xls" with a worksheet "sheet1" and
put something in A1 ("asdf").

And see if the UDF works in that test case.

Maybe it'll help find what's going wrong.

Antonio Duarte wrote:

Hi, Dave:

I really appreciate and thank for your help and the precious time you are
spending with this problem.
I checked your notes, corrected the points you showed (in fact, there was
an error on that point), but the problem still persists.
The pull function keeps returning the errors 2015 or 2023 (as earlier
posted) in the command line:
pull = Evaluate(xref)
Executing the code in the single step mode, I see that the values
assigned to the pull variable after this point we

"Error 2023" or "Error 2015" (depending on the parameter passed)

Then, I did two more tests, simplifying the command line as shown below:
pull = Evaluate("'d:\tmp\[teste2005.xls]Junho'!$B$10")
and also
pull = Evaluate("d:\tmp\[teste2005.xls]Junho!$B$10")

getting the same errors (note that doing so, I 'got rid' of the xref
variable and any 'malfunction' it could lead to).

May be, the problem has been caused by any wrong configuration item in my
Excel. Is it possible? If so, do you have any clue?

Tks again.

"Dave Peterson" escreveu:

ps. Harlan has posted a link to his FTP site a couple of times:
ftp://members.aol.com/hrlngrv/

You can find his pull.zip there (and shouldn't have any trouble with google!)

Antonio Duarte wrote:

Hi, Dave,

The plain old version works fine, but my problem is: I need a VARIABLE
filename.
So, I tryed:

In cell A1 I wrote: D:\temp\[teste2005.xls]

And in Cell A2 I wrote: ="'"&A1&"Junho'!B11"

But all i got in A2 was only the string:
'D:\temp\[teste2005.xls]Junho'!B11 instead the value of the cell.

Can you help?
Tks.

"Dave Peterson" escreveu:

Hmmmm.

I just tried this:

=pull("'C:\temp\[test1.xls]Sheet1'!$A$1")

And it worked fine.

Since you have the string built, maybe you could see what happens with this
plain old version:

="'D:\TMP\[teste2005.xls]Junho'!$B$11"

Does that work?


Antonio Duarte wrote:

Hi, Dave.
Thanks for the information, but for some reason it didn't work.
The situation is:
when I call the pull function this way:
pull("D:\TMP\[teste2005.xls]Junho!$B$11")
(without the " ' " delimiters), the VBA instruction pull = Evaluate(xref)
returns Error
2015 (#VALUE)
and when I call the pull function this way:
pull("'D:\TMP\[teste2005.xls]Junho'!$B$11")
(with the " ' " delimiters), the VBA instruction pull = Evaluate(xref)
returns Error
2023 (#REF)
I just checked, and the conditions a The file acessed really exists under
d:\tmp, and so the WB addressed in the call (Junho!$B$11). When the call is
done, the file is NOT opened.
Do you have any clue on this?
Tks.
Antonio

"Dave Peterson" escreveu:

=indirect() won't work with closed workbooks.

Harlan Grove wrote a User Defined Function that can pull from a closed
workbook:

http://groups.google.co.uk/groups?se...wsranger.co m

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



Antonio Duarte wrote:

Does someone has an answer for the question below?

I have a cell (say A1) with the formula:

=HYPERLINK(€À¦Ã¢‚¬Å“[d:\tmp\file.xls]sheet!B11")

In the next cell, I would like to see the value that the cell pointed by the
hyperlink has. I tried:

=INDIRECT(A1)

But Excel gives a #REF error in the INDIRECT function.



Does someone have any idea on how can I solve this?

Thanks a lot

Antonio Duarte.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson