Excel formatting

[netcashin]

Ok this is probably an easy question.

I am creating an excel file in VB and populating it. I wish to bold a row and change the width properties on a column. How can I do it?

Thanks

 

[jebry]

Hi!

Try using this code:

YourExcelObject.Rows("1:1&quot.FontStyle = "Bold"
YourExcelObject.Columns("A:A&quot.ColumnWidth = 20

Since the Rows and Columns properties need a string argument, you can build in a lot of flexibility if you want to.

hth Jeff Bridgham
bridgham@purdue.edu

 

[wolexie]

try this too

Set myXLApp = createobject("Excel.Application&quot
myXLApp.Visible = True
Set myXL = myXLApp.Workbooks.Add
Set mySheet =myXL.WorkSheets(1)
Set myRng = mySheet.Range("A1&quot

rCount=0

With myRng.Offset(rCount,0)
.Font.Bold = True
.value="This is it"
End With

 

[netcashin]

jebry

thanks that worked.