Cant save workbook....

[rich_drummer]

I have been having trouble trying to save a workbook with a numbe of sheets. My program works by working with an array (like a workbook) of 2D object arrays (analogous to worksheets), instead of working directly with Excel Interop. Once the program is done doing its thing, it copies the arrays to the Excel worksheets like this:

Please Login or Register  to view this content.

The odd thing is that the first sheet saves correctly, but the rest dont save at all...

Does anybody have any ideas???

Rich

[Leith Ross]

Hello rich_drummer,

Have you checked the value of sheet.length? It must be 5, if only 5 sheets are copied.

[rich_drummer]

Oops, i made a mistake, the code should look like this:

Please Login or Register  to view this content.

And, in this case the sheetArray is 12 long and I have confirmed that the workbook contains 12 as well.

[rich_drummer]

Bump (no response)

[rich_drummer]

By the way, sheets is indexed at 1, not 0. SheetArray is an instance of a class I built that contains an array of sheets in the form of a 2D array. I hope this is not all too confusing... Perhaps I need to be more specific.