Changes in Excel from vb.net

[Regal]

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]

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.

 

[Regal]

Thanks will give it a go, up intill now just been going round in circles.