Importing an XML file Into Excel 2003

[Trudye]

I finally figured it out. This is one way to pull an XML file into Excel, you must be running MS Office 2003. I am sure there are better ways but here is what I did.

ActiveWorkbook.XmlImport URL:="X:\Pre-Sale Inspections\outgoing\" & TodaysFile, ImportMap _
        :=Nothing, Overwrite:=True, Destination:=Range("$A$1")

Voila! It was that easy and Dum-Dum me spent 2 days trying to figure it out. FYI: 'TodaysFile' is a global declaration created after formating todays date and concatinating that to a filename.

Hope this helps someone out there,
Trudye