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