Excel Borders (not Pat) [RESOLVED]

[daveStudent]

In vb6 xlTop, xlBottom and others were sufficient enough in defining Cell borders in apps accessing Excel.

In .Net these arent valid. Is there anyway to make them valid or do i need to find the hex values of these?

thx
db

[daveStudent]

For anyone who is interested here's a link i found with ALL the Excel Constants

http://techsupt.windowware.com/TS/T000001033005F9.html

db

[craigreilly]

So - how do I go about actually doing this. I do not understand your reply to your own message. What do I do with those #'s? here is my previous code:

With objexcel.Selection.Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .Weight = xlHairline
        .ColorIndex = xlAutomatic
End With

Thaks for any help you can give...