>>Naomi,
>>I can't thank you enough. I did have a problem getting it to work though. I thought the
release window 'form'
meant to put the form name in 'form' so I used mFormName. I did finally realize that I was supposed to use the line exactly as is. Now I can proceed with processing 225 forms.
>
>
>Ok, that worked for a while but after about 10-15 forms it stops exiting the forms and they again start piling up on the screen. I tried using sleep(1000) after each
release window 'form'
but it made no difference. Anyone got any other ideas? I would like to try oShell.Sendkeys() if I could figure out the syntax.
Are you sure that form can be released OK? Did you try to also release the reference to the variable
oForm = null
release oForm
and also wrap it in try/catch?
If it's not broken, fix it until it is.
My Blog