
December 30th, 2004, 06:35 AM
|
|
Registered User
|
|
Join Date: Dec 2004
Posts: 24
Time spent in forums: 24 m
Reputation Power: 0
|
|
|
how to increase font size of my excel file within vb6
hi
i'm trying to increase font size of only field headings of my excel sheet.my project creates excel file at vb run time and records are coming dynamically from database at runtime itself. but the font of field heading is same as that in the database so i want to increase the size of font and also want to make it bold.
i'm just sending my codes how file is creating at run time and how field headings and records are coming dynamically at run time.
Dim fld as Field
Dim StrHeading1 As String
For Each fld In rs1.Fields
StrHeading1 = StrHeading1 & fld.Name & vbTab
Next
StrHeading1 = StrHeading1 & vbCrLf
Open "abc.xls" For Output As #2 'creates a file in the excel named "abc.xls"
Print #2, StrHeading1 & rs1.GetString(, 100, vbTab, vbCrLf, " "); 'print selected records as per user's condition in the file
Close #2
|