XML creation via a macro

[Sarah Dos Santos]

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?)

 

[Guest]

Sarah
You can write text files using the file system object

Example ... goes something like this
Set MyFs = CreateObject("Scripting.FileSystemObject")
Set MyFile = MyFs.CreateTextFile("C:\Sample.Txt", True)
MyFile.WriteLine "heres some text in a file"
MyFile.Close

Hope this helps