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