Excel functions

[NickCorlett]

Can anybody point me in the direction of a list of functions for formatting Excel spreadsheets within VB, I have no problem creating, depositing the info and saving the sheet, I have also done some basic formatting however I would like a definitive list if possible.

i.e. xlSheet.Cells(intXLRow, intSQLColumn + 1).Font.Bold = True and xlSheet.Cells(1, intSQLColumn + 1).ColumnWidth = 36.

Cheers

 

[HarleyQuinn]

I don't know a link to a definitive list (as you can achieve the same things in Excel several ways) but the way that has always worked for me was to record a macro in Excel, look at the generated code (ATL+F11) and then port that code over to VB. You obviously might have to add loops and sub in some variable names etc. but it's not too far off.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[NickCorlett]

Doh! Yes that would work a treat,

Thanks a lot