Will,
I guess I wrongly assumed that from something I misread in the O¹Reilly
book sorry. In any case, the issue I¹m having is trying to pass the
contents of a 2D array directly to an Excel range (via OLEObject) as in VB
since the compile error I get says expecting Variant - not allowing
Variant(). So I loop through the contents of a multi column listbox and
create an array to hold the values. I want those values in an Excel
spreadsheet. If I loop through, inserting values, it takes forever about
a second per record (at 29 columns). Does anyone know a trick or can help
me transfer the array or list values into Excel faster?
If I create a 1D array, I assume it will work but then it still requires a
loop to separate the ³records² - any ideas?
-seanA
On Thu, 15 Jul 2004 07:47:55 -0500, Sean Arney <sean at rulessoftware dot com>
wro=
te:
> Am I limited to a For loop and a column counter and then pass a single
> dimension array? Is this issue part of the idea that RB doesn=B9t really=
have
> multi dimension arrays?
REALbasic has multi-dimensional arrays. What makes you think it doesn't?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|