How to read in cell border?
 

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.

How to read in cell border?
 

On Feb 7, 4:04*pm, wrote:
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

How to read in cell border?
 

On Feb 7, 10:18 am, wrote:
On Feb 7, 4:04 pm, wrote:

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

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.