Import & Export Excel as XML

**okelly** · 11-10-2007, 10:27 AM

hello all,

Has anybody got any good VBA to export Excel tables as XML, and alternatively import XML into Excel with VBA.

Thanks in advance
Conor

**michelxld** · 11-12-2007, 12:20 PM

Hello

This macro use A1:F20 content to create an xml file.

Please Login or Register  to view this content.

This macro import xml file in worksheet

Please Login or Register  to view this content.

(Created with Excel2007)

Regards
michel

**okelly** · 11-15-2007, 01:48 PM

thanks Miclexld. Works fine

**daxsharma** · 06-26-2012, 11:44 AM

Hi,
I tried to use the macro above,
it showed up as an error to me.
"Sub CreationElement(strElem As String, Donnee As Variant, oNom As IXMLDOMElement"
compile error, User defined type defined.

Please help. I am kinda struggling to merge 10 XML files (with same tags and different data) into a single one.

Thanks in advance..

Import & Export Excel as XML

LinkBack

Thread Tools

Rate This Thread

Display

Import & Export Excel as XML

Re: Import & Export Excel as XML

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions