Changes in Excel from vb.net

Regal

New member
Joined
Apr 28, 2005
Messages
2
Programming Experience
Beginner
After opening a excel sheet from a vb.net program i have managed to change the font to bold using xlSheet.Range("A3").Font.Bold = True.... but how do i change a cell colour, draw boarders around one or more cells and insert a page breaks. Hope i have not asked to much.

Rich...
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,335
Location
Sydney, Australia
Programming Experience
10+
I have done a little Excel manipulation from VB. I can't claim to know exactly how to do the things your asking, but if I wanted to know I would use the Object Browser in VS along with the Excel Help system. If you have a reference to Excel in your project, the Object Browser will include all Excel objects, etc. although you won't be given a description of anything. Usually the names give you a pretty good idea of what the item is, then you can look for it in the Visual Basic Reference section in the Excel Help system. I used this method to find information on inserting page breaks in about 45 seconds.
 
Top Bottom