Well I've checked out the XML Parser - it's way too complex for me to
program it to perform what I need. Guess it's back to Excel Macros


On Thu, 4 Sep 2003 17:01:24 +0100, "Keith Willshaw"
wrote:


"John" wrote in message
.. .
I'm trying to convert an XML file into an Excel database using a macro
but don't know where to even start (a newbie if you will).
The XML file format appears as listed below.
What I'd like to get the macro to do is take the headers (ie.
<REPORT_DATE, <DOMAIN_RECORD, <ADDRESS, etc) into proper records &
fields as: Rep_Date, Dom_Rec, Web_Addr,IP_Addr, Owner, Street,
City/State, Country, Phone, Fax, Email, etc
In the case where no info is available, that field would be left
blank.

Any help would be greatly appreciated as I've been trying to find
software to do this but have been unsuccesssful. It appears that a
macro would do the trick.


John

You can download and use the XML parser from the
Microsoft web site and write your own input routines
but I believe Excel 2002 has inbuilt XML export and import
filters to do just this. Upgrading may well be the simplest
option for you.

Keith