View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sarah Dos Santos Sarah Dos Santos is offline
external usenet poster
 
Posts: 1
Default XML creation via a macro

I have a spreadsheet containing results data for a group
of students. I know the name of the xml tags (elements) -
I want to write a macro that will output the data with the
relevant tags to an xml file. Any ideas?

I've got excel 2000 - does the visual basic in this
version allow information to be written out to an external
file (streamwriter?)