Generating XML from Excel2002 using XSD

Ben

Guest

Posts: n/a

9th Nov 2006

Hi
I understand that XL2003 offers nice XML features that could do what I
want easily.
But I am not sure about what XL2002 Pro can let me do.

I need to generate pretty basic XML in Excel 2002 VBA.

I have an idea of my XSD schema -
say Author --> [Name -once ]/[Email- unbounded]l/[Book -unbounded -->
Title/Publisher/ISBN]
Data comes from Excel

Can you give a basic code of how I should use VBA in conjunction of the
XSD file
I have access to msxml and msxml4 DLLs

Thanks a lot
Ben

« excel time calculation | Filtering »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel2002	JWD	Microsoft Excel Setup	0	9th Nov 2009 04:55 PM
Excel2002 vs. Excel97	rose	Microsoft Excel Misc	0	3rd Mar 2004 05:19 PM
excel2002	elwyn	Microsoft Excel Discussion	2	11th Nov 2003 11:54 PM
ASC( ) in EXCEL2002	chengj	Microsoft Excel Worksheet Functions	0	31st Oct 2003 02:39 AM
different behavior in Excel2002	igodzin@lehman.	Microsoft Excel Discussion	0	24th Oct 2003 08:58 PM