Calling a bit of code from a sheet errors

G

gearoi

I have this bit of code which messes up every now and then, but not al
the time at all - I'll try anything to make it work!!! :)

Application.Run "WorkInProgress.xls!Sheet7.CommandButton1_Click"

(Have also tried
Sheet7.commandButton1_Click
and
call xxx with both of the above)

And it works MOST of the time - ie it tends to run about 6 of the 20
of these things that I'm doing then it stops. Then it falls over with:

"Method "Run" of object "Application" error (or similar).

Basically it crashes and stops....

But I need it to run through hundreds of times. This is a clear VB
shortcoming and I was wondering if anyone has a workaround?

Thanks in advance,
Graham.

PS using Excel 200
 
D

Dave Peterson

You're running this code from a different workbook?


I have no idea. But if you move the code to a general module and call that
procedure, does it work more consistently?

(You'd have to call that procedure from the _click event, too if you didn't want
to duplicate the code.)
 
G

George Nicholson

Try inserting a "Do Events" line before Application.Run.

If it runs 6 times and then dies, the computer may simply need a second to
catch up with executing code. Worth a try.

HTH,
 
Top