How to Represent an XML Document in VBA


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
    Location
    Orange, California
    Posts
    1,263

    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
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

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, 10:37 AM
  5. how to represent int64 in VB?
    By - John of Arc - in forum VB Classic
    Replies: 0
    Last Post: 03-11-2000, 11:37 PM

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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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