Outlook VBA - Trust access

[Andrzejek]

To get the values in Excel with this line:

[tt]Application.VBE.ActiveVBProject.VBComponents.Count[/tt]

I needed to go to: File - Options - Trust Center - Trust Center Settings - Macro Settings
and check Trust access to the VBA project object model

What do I need to do / set in Outlook to be able to run the same line:
[tt]Application.VBE.ActiveVBProject.VBComponents.Count[/tt]


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[strongm]

Good luck with that. Microsoft removed access to the VBEIDE library in Outlook years ago. Considered too much of a security risk (higher security risk than in other Office applications)

 

[hermanlaksko]

Try this
Sub OpenTrustCenter()
Dim MSec As Integer, OApp As Object
Set OApp = CreateObject("Outlook.Application")
MSec = OApp.Application.explorers.Item(1).CommandBars.ExecuteMso("MacroSecurity")' This will open the trustcenter for the user to change the current setting.
End Sub

 

[hermanlaksko]

MSec = OApp.Application.CommandBars.ExecuteMso("MacroSecurity") ' Perhaps this i the line in access 2016