VBA help - Eliminating loops?

[Spike]

Hello, can anybody help me with these problems?

Problem 1:
I'd like to bring prices in using the COM and write them to an array variable without using a loop - is this possible?
At the moment I use a loop along the lines of:

For Each priceitem In prices

backPrice(I) = priceitem.backodds1
I = I + 1
Next

Ideally I'd like to just get it done in one swift operation - any ideas?

Problem 2:
Again, using the COM I'd like to place several bets simultaneously without using a loop, I have all the data stored in Array variables, so say I have the selections, prices and stakes stored in variables called selections(), prices() and stakes() with each corresponding to the other - so selection(1) goes with prices(1) and so on. How do I place all those bets at once without a loop?


Any help with either or both of these questions would be much appreciated.

[GaryRussell]

Sorry, it's bad news. It's not possible to do either of these without using loops. The Prices object would need to provide a method to return an array which it doesn't and there isn't a place bet function that accepts an array. It's not impossible for me to provide the options I just haven't yet.

[Spike]

Thanks for getting back to me so quickly Gary. At least I know not to waste time agonising over it!

If you do get round to including this functionality it would be terrific but I imagine it's not likely to make the top of your list for a while and that's fair enough.