Results 1 to 2 of 2

Thread: Re: code to convert an excel sheet into an XML file

  1. Apr 17th, 2008, 08:19 AM #1
    meetvinesh
    meetvinesh is offline

    Thread Starter
    New Member
    Join Date
    Apr 2008
    Posts
    2

    Re: code to convert an excel sheet into an XML file

    Hi

    i have a requirement like this . I have an excel sheet which contains data in 5 rows and 5 columns and the data in the first row is considered as headings of the columns. I need to convert this excel sheet into an xml file programatically using VBA. so please any one help me in this regard as i need the code very urgently. The xml file must be in the form of nodes as of normal xml files



    Regards,
    satyam reddy
    Reply With Quote Reply With Quote
  2. Apr 17th, 2008, 04:19 PM #2
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: code to convert an excel sheet into an XML file

    i believe in later versions of excel you can saveAs to create an xml file
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width