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

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

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

Bob,
You can a help file on this from MS:
http://support.microsoft.com/kb/q128185/

NickHK

"BobMartin776" wrote in message
...
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