[Open Office] Re: Pending task for VBA macro - OOo interop

[Shilpa Sreeramalu]

On Fri, 2005-09-02 at 12:21 +0100, michael meeks wrote:
> Hi there,
> 
> 	Prolly best to discuss on the mailing list I guess - since almost
> everyone is involved ;-) Also - IMHO it'd be best to start discussing
> this sort of thing on the public list I think. Apparently Sun is less
> annoyed than I thought about us working on this.

> 
> Misc tasks:
> 

> 	3.3 - 'for each' doesn't work ?
	The for each syntax is generally used with the collection  objects.
Excel mostly does something of thsi kind:
	Dim wksh as Worksheet
	for each wksh in ActiveWorkbook.Worksheets
		MsgBox( wksh.Name)
	next
	This doesn't work in the current scenario. It crashes with the
worksheet object sometimes, sometimes raises an exception.

Regards
Shilpa