View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] huyeote@gmail.com is offline
external usenet poster
 
Posts: 2
Default Remove VBE Component failed

Thanks Jim,

I used F8 to step through the code and watch the changes in VBE's
Project Explorer windows and found my code worked in some workbooks.
However in some other workbooks the wierd thing is the module still
remained after getting past the .Remove method and no error was
reported. And then a new module with the same name and indexation (eg.
module1 or module2) was injected after the execution of importing code
from a temp file which was not quoted here.

A possible bug in VBA?

Huyeote

On Nov 17, 1:09 am, "Jim Rech" wrote:
Looks like it should work. The next step is to step through the code and
see why it doesn't. No chance the module remaining is the one with this
code in it right?

--
wrote in message

...