ShellExecute via VB to Excel

[ThomasJosephScanlon]

My vb code utilizes the FarPoint(2.5.40) spread control which I load the ResultSet.Fields(i).name and ResultSet.Fields(i).values. When I execute the following code( bSave = vaSpreadResults.SaveTabFile("C:TEMPConstructionAnalysis.xls"))
and ShellExecute to excel, I only get the values and want to also get the column names displayed? How can I accomplish this?

Thanks

 

[ThomasJosephScanlon]

Heres the fix I made fyi:
Instead of loading the farpoint spread
row 0 with rs.fields(i).name I load it to
row 1, all subsequent rows in rs increment
from row 2 forward. This allows the export
to excel to utilize the SaveTabFile and shell out to excel displaying the headers
followed by values.