ShellExecute via VB to Excel

ThomasJosephScanlon · Apr 2nd, 2002, 11:20 AM

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 · Apr 3rd, 2002, 02:46 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 11:20 AM	#1
ThomasJosephScanlon New Member Join Date: Apr 2002 Posts: 2	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

Apr 3rd, 2002, 02:46 PM	#2
ThomasJosephScanlon New Member Join Date: Apr 2002 Posts: 2	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.