"Run as Administrator" - stops VBA hooking up to EA

[Paolo F Cantoni]

We have a number of Side-Ins written in various forms of VBA.  We've just noticed that if we run EA as Administrator, the VBA code can't find the EA Application (as the VBA code initialises).

Anybody know what's going on?

TIA,
Paolo

[Geert Bellekens]

You'll have to run the VBA as administrator as well.

Technically you are running the EA process under a different (admin) user.
Your regular user running the VBA doesn't have access to the admin EA process.

Geert

[Paolo F Cantoni]

You'll have to run the VBA as administrator as well.

Technically you are running the EA process under a different (admin) user.
Your regular user running the VBA doesn't have access to the admin EA process.

Geert

That's what I thought, BUT I don't seem to have any way to run Excel (in this case) as Admin - the dialog is greyed out; I can't select the checkbox.

I don't need EA to be in Admin user for this process, it's just an annoyance to exit and re-enter.

Paolo

[Glassboy]

That's what I thought, BUT I don't seem to have any way to run Excel (in this case) as Admin - the dialog is greyed out; I can't select the checkbox.

Create a shortcut to cmd.exe on your desktop, run it as as admin.  Run Excel.