Need sample code to convert xml file to excel

Message Topic Search Topic Options Post Reply Create New Topic Printable Version

   Hi,

I am working on converting xml file to excel using vbscript.

Could anyone provide me with some sample code to convert xml file to excel, please.

I am very much in need of this sample code. Please assist me in this regard.

Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version
sharath.poluru Members Profile Find Members Posts Add to Buddy List I'm new here Joined: 16 Oct 2009 Online Status: Offline Posts: 2	Quote Reply Topic: Need sample code to convert xml file to excel Posted: 25 Feb 2010 at 22:08
	Hi, I am working on converting xml file to excel using vbscript. Could anyone provide me with some sample code to convert xml file to excel, please. I am very much in need of this sample code. Please assist me in this regard. Thanks

jhicks Members Profile Find Members Posts Visit Members Homepage Add to Buddy List MVP Joined: 10 Mar 2010 Location: United States Online Status: Offline Posts: 3615	Quote Reply Posted: 15 Mar 2010 at 09:55
	I would begin by recording a VBA macro to open the XML file as a workbook. Then you can begin revising the VBA code into a stand alone VBS script. If you get stuck, post the VBA code and what you have for the VBS.