Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Dallas, TX
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting XML to excel 2000 (Excel 2000)

    I have the ability to dump member information into an XML file, is there a way to import that information in an excel file?

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Re: Converting XML to excel 2000 (Excel 2000)

    attach a small sample and I'm sure someone could tell you

    zeddy

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Converting XML to excel 2000 (Excel 2000)

    I'm not sure if 2000 works the same way as XP in this regard (with or without additional downloads), but you could review these articles for general information:

    XL2002: Opening XML Files in Excel (Q282161)

    Microsoft Office XP Developer: XML Support in Excel

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Converting XML to excel 2000 (Excel 2000)

    Hi,
    The simple answer is yes. You will need to use VBA however as versions prior to 2002 do not have the ability to natively open or import XML documents. If you set a reference in your project to Microsoft XML, you can then use the DOMDocument and various other objects etc to manipulate your data. How complicated it will be depends entirely on the document you're trying to import!
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •