Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Calgary, Alberta
    Thanked 1 Time in 1 Post

    xml and excel 2000 (Excel 2000)


    I have a question about using XML in Excel 2000,

    I have a workbook which is a template and hold alot of data, every time the template is used it makes a report about 30 times a day. right now i am saving the excel file as a whole giving it the hefty size of 3 mb (3mb * 30 = 90 mb). I was wondering, if there would be a way i could save the data in the template in XML format, and if i want to bring the data up in the excel template later the data in xml format would load into the appropiate fields, this would save alot of computer memory.

    I know excel 2003 has the xml function not sure if its ment to do this,
    I hear that 2007 will actually save xml excel files and not the bulk excel file.

    is excel 2000 able to handle this in any manner?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts

    Re: xml and excel 2000 (Excel 2000)

    There are no built in methods in Excel 2000 to do this.
    You could write VBA code to handle the saving to XML and fetching the data from an XML file using the XMLDOM object library though.

    I'm sorry to say I have no sample code I can show you though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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