| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Invalid index in foreach(HPageBreak hpb in sheet.HPageBreaks)
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ForEach statement problem | Excel Programming | |||
| Renamed invalid sheet name | Excel Discussion (Misc queries) | |||
| Runtime Error 381 Couldn't set list property, invalid array index | Excel Programming | |||
| Runtime Error 381 Couldn't set list property, invalid array index | Excel Programming | |||
| ForEach procedure adding values | Excel Programming | |||
Hybrid Mode
