View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
L. A. M. L. A. M. is offline
external usenet poster
 
Posts: 8
Default How to handle error 8007000e Memory Error

Hello Tom, the commandbutton doesn't show any aditional userform. Only it
execute a VBA procedure opnening other workbooks.

Luis

"Tom Ogilvy" escribió en el mensaje
...
If you unload and show the original userform or show another userform and
that userform shows the original useform perhaps based on a button click,
then your routine may not have ended as you think it has.

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi Tom, yeah, the first time that I click the commandbutton everything is

ok
(The first time the procedure is ligthly different to the second time).
Curiosly, it happens only with the procedure linked to this button.

Thanks for your help

Luis


"Tom Ogilvy" escribió en el mensaje
...
Has the code terminated from the first time you clicked the button?

--
Regards,
Tom Ogilvy


"L. A. M." <luism0(arroba)yahoo.es wrote in message
...
Hi

When I click on a userform commandbutton for the 2nd time, the

following
error appears:

Run-time error '-2147024882 (8007000e)Not enough storage is available

to
complete the operation'

Thanks for suggestions

Luis