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

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

"Sarah Dos Santos" wrote:

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