Excel4Macro(arg)

[BobMartin776]

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

[Tom Ogilvy]

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

[BobMartin776]

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

[NickHK]

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

NickHK

"BobMartin776" <BobMartin776@discussions.microsoft.com> wrote in message
news:9CF79789-2D12-4E35-B74C-95C25EA7CA8F@microsoft.com...
> 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