DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to Represent an XML Document in VBA

  1. #1
    Join Date
    Aug 2004
    Orange, California

    How to Represent an XML Document in VBA

    I have an access database and I need to add the ability to export orders into an xml file. I have been given an XSD file and a sample XML file to work with.

    Now I could hard code the whole thing, but I was wondering if anyone has come up with a way to represent an xml document through some type of a class or class's.

    If I could represent the Document in some type of structure that I could fill in the various elements and properties and then have it generate the XML text that would be saved to the appropriate file.

    This way it would be eaiser to create new documents, or even create new versions of existing ones.

    I am looking for any Ideas or suggestions on how to get started?

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Are you compelled to use VBA for this project?

    I had to do something similiar for one project. I do not know if this is the best way, but I dumped what I needed from my Access database table(s) into an excel spreadsheet, and then used the .NET code example I found here to convert it into XML

Similar Threads

  1. Letters to represent numbers Excel
    By ABFABROB in forum .NET
    Replies: 1
    Last Post: 07-27-2009, 05:17 PM
  2. Replies: 3
    Last Post: 06-04-2002, 10:57 PM
  3. What is &HFF00& represent in VB?
    By anonymous in forum VB Classic
    Replies: 2
    Last Post: 05-11-2001, 08:21 PM
  4. how to represent int64 in VB?
    By - John of Arc - in forum VB Classic
    Replies: 24
    Last Post: 03-14-2000, 11:37 AM
  5. how to represent int64 in VB?
    By - John of Arc - in forum VB Classic
    Replies: 0
    Last Post: 03-12-2000, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center