View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default method vbproject of object workbook fail

You'll need to show us your code

The following for example
MsgBox ActiveWorkbook.VBProject.VBComponents.Count
works fine without any extra references.

Show us the context in which you use the object, and then
we may be able to identify and resolve your issue.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I get this error every time The code

activeworkbook.vbproject...... is used.

i have ticked the "Microsoft Visual Basic For

Applications Extensibility 5.3". in references

can someone help
.