Am 21.12.2017 um 22:47 schrieb :
On Thursday, December 21, 2017 at 3:42:30 PM UTC+11, GS wrote:
Is it possible from VBA to run excel as administrator so that VBA routines
that create an instance of Outlook or Word will run as per normal.
Please explain what you mean by "run as per normal". (What abnormal behaviour
are you getting?)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
If Excel is not running as an administrator the vba routine that creates the object (CreateObject("Outlook.Application")) doesn't have permission to create an instance of Outlook (or Word).

It works okay on my computer as I have excel set to run as administrator, but it doesn't work on other computers. I can't go an change the settings on all the other computers.

Check the dcom settings to see if they are correct and change them if
necessary.

Some hints can be found he
https://stackoverflow.com/questions/...mission-denied

Ulrich