Thanks Tom..
My problem is another issue...the program throws exception when it execute
HPageBreak hpb = sheet.HPageBreaks[i];

Usually, I call ResetAllPageBreaks(); before I get the page breaks. If I
dont reset them, the program works well.

"Tom Ogilvy" wrote:

http://support.microsoft.com/kb/210663/en-us
You receive an"Subscript out of range" error message when you use
HPageBreaks or VPageBreaks.Location in Excel


--
Regards,
Tom Ogilvy

"Amy" wrote in message
...
My program got the following exception while parsing some excel files
(they
usually contain some manual page breaks):
Exception from HRESULT: 0*8002000B <DISP_E_BADINDEX

I used
sheet.HPageBreaks.Count
found it contains 5 objects...
my program can get the first two objects successfully, how ever, it cannot
load the left.

Does anyone know why?
Thanks for any comments.