Excel book.SaveAs

[TheVig]

I'm working with some data where I need to write a bunch of rows for an excel file.

Using SetCell takes too long...So I thought I'd write to a tab separated text file, then open and saveas in Excel:
Function OpenSaveExcel

Code:

Copy      Help

str filename="$temp$\data.txt"
filename.expandpath
ExcelSheet es.Init("" 8 filename)
filename.timeformat("$desktop$\{yyyy}-{MM}.xls")
filename.expandpath
es.Save(filename)

Essentially it is using Excel to convert a tab separated text file to convert it to an .xls.

This works, except for that any cell with a formula is saved as its value only, which I need the formulas to remain in tact.

Is there any way to work around this? A better SaveAs excel function? A better way to convert tab separated data to an .xls?

Thanks,
jimmy Vig