Thanks guys, I haven't tried System.IO.File.Move("c:\test.txt",
"c:\test.xls") yet, but I have found that the following code will magically
produce an Excel file with cells A1:A5 populated: This is not documented
anywhere, I just tried it to see what would happen!
Dim pathAndFileName As String = Server.MapPath("Data/Test.xls")
Dim sr As StreamWriter = File.CreateText(pathAndFileName)
Dim xData, str_1,str_2,str_3,str_4,str_5 As String
str_1="This"
str_2="is"
str_3="a"
str_4="Test"
xData = "str_1 & vbTab & str_2 & vbTab & str_3 & vbTab & str_4
sr.WriteLine(xData)
sr.Close()