LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default macro code for XML Fill

Dear friend,
i need to read xml and i need to fill in my excel workbook

for example
i need to loop through the xml and fill values in my EXcel Workbook the
example
for loop xmldatas
ColumnA :id
columnB :name
columnC :mark
columnD:designation
next

so like this i need to fill my excel values.can u please help me to do this
please friend

this is my xml:

<?xml version="1.0"?
<data
<student
<id1</id
<nameRaymond</name
<age11</age
<mark0</mark
<designationengneer</designation
</student


<student<id2</id
<nameMoon</name
<age11</age
<mark100</mark
<designationblody</designation
</student


<student<id3</id
<nameBilly</name
<age11</age
<mark100</mark
<designationpassd</designation
</student


<student<id4</id
<namePan</name
<age12</age
<mark80</mark
<designationvhonr</designation
</student


<student<id5</id
<nameQueenie</name
<age10</age
<mark90</mark
<designationsogjg</designation
</student


</data
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to fill down Secret Squirrel Excel Discussion (Misc queries) 6 May 23rd 08 05:48 PM
auto fill code balu Excel Discussion (Misc queries) 3 November 19th 07 07:08 PM
sub won't fill down via code SLP Excel Programming 3 November 2nd 07 05:38 PM
Fill down - adjust code J.W. Aldridge Excel Programming 2 August 4th 07 02:46 PM
List Fill Code Cody Excel Programming 5 August 2nd 05 05:19 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"