Outlook VBA - Trust access

Andrzejek · Jun 18, 2024

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]
[ponder]

---- Andy

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

strongm · Jun 18, 2024

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 · Aug 16, 2024

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 · Aug 16, 2024

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Outlook VBA - Trust access

Andrzejek

Programmer

strongm

MIS

hermanlaksko

Programmer

hermanlaksko

Programmer

Similar threads

Part and Inventory Search

Sponsor