ActiveWorkbook.VBProject VBComponents

[drom]

Thanks in advance!

I already know this web:

http://www.cpearson.com/excel/vbe.aspx

I have checked the following reference whithin Excel VBA's references Manually:

Microsoft Visual Basic for Applications Extensibility 5.3


BUT when I run the following Macro, once checked the prior reference:

Sub AddModuleToProject()
  On Error Resume Next
      Debug.Print Err           ' I GET 0
Dim VBProj As VBIDE.VBProject:      Set VBProj = ActiveWorkbook.VBProject
      Debug.Print Err           ' I GET 1004
Dim VBComp As VBIDE.VBComponent:    Set VBComp = VBProj.VBComponents.Add(vbext_ct_StdModule)
      Debug.Print Err           ' I GET 91
    VBComp.Name = "NewModule"
      Debug.Print Err           ' I GET 91
End Sub

Why I get those errors.

What am I Missing??

 

[drom]

Do you have Trusted Acc ess to VBA projects set? This would be my guess.

Is the project password protected?

Is the project password protected? NO

Do you have Trusted Acc ess to VBA projects set? I don't understand your question
Acc ess?
project set?



PS: Thanks!

 

[xld]

Goto Tools>Macro>Security...>Trusted Publishers, make sure that the Trust Acces to Visual Basic Projects is checked.

 

[drom]

Goto Tools>Macro>Security...>Trusted Publishers, make sure that the Trust Acces to Visual Basic Projects is checked.

[SOLVED]

Many Thanks!!!!!

 

[MalaysiaExcelExpert]

Do you have Trusted Acc ess to VBA projects set? This would be my guess.

Is the project password protected?

I have found a solution to this too


If you are using Excel 2007/2010, you need to add the VBA project as trusted publisher by following this step:

Click on File tab, choose Options
in Excel Option dialog, choose Trust Center
then click on Trust Center Settings button
in Macro settings pane, check the Trust access to the VBA project object model

then click OK button to close the dialog.

Hope this will help some Malaysian. Have a nice day.

Many thanks to CPearson for writing a detailed article to use VBA
Programming In The VBA Editor