Calling a bit of code from a sheet errors
 

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

Application.Run "WorkInProgress.xls!Sheet7.CommandButton1_Clic k"

(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 200
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 VBA
shortcoming and I was wondering if anyone has a workaround?

Thanks in advance,
Graham.

PS using Excel 2000


--
gearoi
------------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=436808

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.)



gearoi wrote:

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

Application.Run "WorkInProgress.xls!Sheet7.CommandButton1_Clic k"

(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 200
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 VBA
shortcoming and I was wondering if anyone has a workaround?

Thanks in advance,
Graham.

PS using Excel 2000

--
gearoi
------------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=436808

--

Dave Peterson

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,
--
George Nicholson

Remove 'Junk' from return address.


"gearoi" wrote in
message ...

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

Application.Run "WorkInProgress.xls!Sheet7.CommandButton1_Clic k"

(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 200
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 VBA
shortcoming and I was wondering if anyone has a workaround?

Thanks in advance,
Graham.

PS using Excel 2000


--
gearoi
------------------------------------------------------------------------
gearoi's Profile:
http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=436808