Hi BobBridges,

Based on the name of the product, this fairly old technology, 10 years old.  You might have found this KB Article that does include references for older versions of Attachmate Extra!. Possibly someone in the community can help, but if you need support from Micro Focus, please e-mail or call us 800-688-3270.

Regards,

Jeff

Thanks for the references, Jeff.  I will certainly keep these and refer to them once I get back to this project.  I think I have the immediate solution—in two different ways, actually.

At the time, it  finally occurred to me that the time it takes for the mainframe to scroll from one panel to the next will take up most or all of the time I would save by working with arrays anyway.  In other words, if I write the data to cells individually, yeah, it'll take many minutes to fill up thousands of cells—but it would take that long to scroll through hundreds or thousands of panels anyway.  So I wrote it that way; I think the entire program runs in 5 or 10 minutes.

But recently I was writing a VBS program for Excel and ran into a similar problem, going the other way:  I wanted to assign a range of an Excel worksheet to an array—again, to save considerable time—and wscript kept telling me it was an error, a type mismatch I think.  I experimented with many ways of allocating the array, and trying to match up the array bounds with the cell bounds in the worksheet, before I accidentally stumbled on the solution:  If I don't Dim and Redim the array at all, just assign it the Excel range as if the array variable is scalar, it works fine.  (Furthermore, the lower bound of the array is 1, instead of 0 as is usual in VBScript.)

In the program I asked about here the problem isn't the same, because it's trying to go the other way, ie load up an array and dump it into a worksheet.  But I have hope that this'll give me some new ideas.

And if not, as soon as I'm back on this project I'll look up your references.  In fact I will anyway, because I'm still hoping to find a reference not just on the Extra! object model but more information on the VB flavor, too.  Thanks again.

Thanks for the references, Jeff.  I will certainly keep these and refer to them once I get back to this project.  I think I have the immediate solution—in two different ways, actually.

At the time, it  finally occurred to me that the time it takes for the mainframe to scroll from one panel to the next will take up most or all of the time I would save by working with arrays anyway.  In other words, if I write the data to cells individually, yeah, it'll take many minutes to fill up thousands of cells—but it would take that long to scroll through hundreds or thousands of panels anyway.  So I wrote it that way; I think the entire program runs in 5 or 10 minutes.

But recently I was writing a VBS program for Excel and ran into a similar problem, going the other way:  I wanted to assign a range of an Excel worksheet to an array—again, to save considerable time—and wscript kept telling me it was an error, a type mismatch I think.  I experimented with many ways of allocating the array, and trying to match up the array bounds with the cell bounds in the worksheet, before I accidentally stumbled on the solution:  If I don't Dim and Redim the array at all, just assign it the Excel range as if the array variable is scalar, it works fine.  (Furthermore, the lower bound of the array is 1, instead of 0 as is usual in VBScript.)

In the program I asked about here the problem isn't the same, because it's trying to go the other way, ie load up an array and dump it into a worksheet.  But I have hope that this'll give me some new ideas.

And if not, as soon as I'm back on this project I'll look up your references.  In fact I will anyway, because I'm still hoping to find a reference not just on the Extra! object model but more information on the VB flavor, too.  Thanks again.