Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb.net & excel properties
I am using vb.net 2005 to fill a spreadsheet in excel with data. I
have gotten the data in the speadsheet and now I am not to formatting. I can change text justification by: ..HorizontalAlignment = 3 'Centers Text in the cell I am having trouble with the borders. I have searched the group and recorded macros and found things like .xlEdgeBottom and changing the ..LineStyle, .Weight, etc... properties. Is there a way to get vb to recognize the .xlEdgeBottom and .LineStyle etc. instead of having to figure out the integer equivalents like I did with the text justification? There are many more properties for the border than there was for text justification so trying all the possibilities will take a lot more time. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Properties | Excel Discussion (Misc queries) | |||
Excel Properties | New Users to Excel | |||
Properties transferring from excel cells to word file properties | Excel Programming | |||
Excel properties | Excel Programming | |||
Excel properties | Excel Programming |