View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Excel Macro via VBA - XML IMPORT

What I'm not sure of if each row will have the same columns in the same
order. the tagnames are really the column headers You may need to
re-arrange the code to use the tagname to find the correct column when
reading the XML. Let me know if you need more help.

"Virgil" wrote:


Thanks Joel, the foreach is much cleaner and easier to understand and the
row handling now makes sense for me.

Yes each row has more than 20 colums and only some of these will be
referenced in the XML

Thanks again.