View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Avery R Avery is offline
external usenet poster
 
Posts: 220
Default VBA Extensibility problem

I have the following problem:

For some reason, seemingly at its whim, VBA inserts an extra line
containing only "()" after my code when i add code to a new module using

..CodeModule.AddFromString strCode

This only happens about 1/15 of the time, but it does so consistently.
I have checked the strCode, and there NEVER appears parentheses like
that anywhere. I also checked using debug.print strcode. But VBA
inserts the additional "()" line.

Any suggestions? Any help would be most appreciated.