Problems Opening Excel *** in 2003 ( Fujitsu PowerCobol 6.1)

From: James Sugrue (jamessugrue_at_xtra.co.nz)
Date: 11/29/04 

Date: Tue, 30 Nov 2004 09:41:11 +1300

This question has been asked in other threads, but I thought I would put
it in it's own thread...

I can open excel files using the "OpenBook" method of the Excel control.
  That works fine and I can move data to cells and save to book ok. This
only seems to work with the first *** in the collection.

If I want to access say the third *** in the Workbook it doesn't work.

I use this to try and open the 5th *** in the workbook:

Invoke CmExcel1 "OpenBook" using book-name idx.

Where idx is of type PIC S9(9) COMP-5. I move 5 to idx before issuing
the openbook command. It opens the Workbook, but onto sheet1 not sheet5.

Any ideas?

Quantcast