How to read in cell border?

[gdu]

Hi, Excel gurus,

When I open an Excel file and read in cell contents and formats, how
do I obtain cell border format? I need to know the kind of border
(type, style, line thickness, etc) of each cell. Thanks.

 

[paul.robinson]

Hi, Excel gurus,

When I open an Excel file and read in cell contents and formats, how
do I obtain cell border format? I need to know the kind of border
(type, style, line thickness, etc) of each cell. Thanks.

Hi
Record a macro as you apply these formats and see what you get.
regards
Paul

 

[gdu]

Hi
Record a macro as you apply these formats and see what you get.
regards
Paul

I am doing this from a VB6 program and I tried to use
xlsht.cells(ii,jj).borders.value through all cells concerned. But I
get error message of null.