[Openroad-users] Activating Excel Worksheets

[HUMPHERSTON, Richard]

Dear All,

Openroad 4.1 0109 on Windows 2000 / 98 / NT 4.0

We have an issue relating to the activation of excel worksheets from an
OpenRoad application component.  On clicking the Excel menu button a
procedure is called which opens a named excel workbook template and pushes
data sets into 5 separate worksheets.  This procedure works without error
when initiated through the development environment. However, when this is
attempted through a compiled image at runtime, only the first data set is
pushed to the workbook. No runtime errors are reported, but the trace window
displays the following message :-  E_WT0028 Returning from stat_excel_fp due
to error.  
            E_WT0033 Row 2 is out of range for an array access. 
            An attempt was made to access row 2 of an array. 
The array does not contain row 2. 

I have traced this error to the following piece of code :- 

        IF i > 1
        THEN
          sht[i].Activate();
        ENDIF;  which is within a

FOR loop i = 1 to an array lastrow. 

The declarations for sht are :-  

  sht = excel!Sheets collection of excel Worksheet; 

and in the initialize block :-  

  sht = wbs.worksheets(); 

Can anyone shed any light as to why this approach works from the development
environment, but fails at runtime ?

CA suggested a service pack upgrade which we performed to no avail.

I can supply the procedure in full.

Thanking you.

Richard Humpherston.
richard.h...@atosorigin.com
 

_______________________________________________________

This e-mail and the documents attached are confidential and intended
solely for the addressee; it may also be privileged. If you receive this
e-mail in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin group
liability cannot be triggered for the message content. Although the
sender endeavours to maintain a computer virus-free network, the
sender does not warrant that this transmission is virus-free and will
not be liable for any damages resulting from any virus transmitted.
_______________________________________________________

_______________________________________________
Openroad-users mailing list
Openroa...@peerlessit.com
http://www.peerlessit.com/mailman/listinfo/openroad-users