Thanks. Finally got it to work. In the book, a back-slash after the
directory name is missing.

"Tom Ogilvy" wrote:

Works fine for me and many others.

well for the full truth, I haven't used the book's version, but I am sure it
is the same as this

http://www.j-walk.com/ss/excel/tips/tip82.htm

which I have used.

--
Regards,
Tom Ogilvy


"BobMartin776" wrote:

Has anyone been able to retrieve values from closed workbooks using the XML
macro called Excel4Macro(arg)? I can't get it to work using the procedure
described in Walkenbach's book "Excel 2003 Power Programming with VBA", pages
353-355. Will appreciate any tips.

Bob Martin