Excel Automation Weird Behavior?

[sergioza]

Hi,

I wonder if there are any Excel automation Experts who can help explain and solve the following:

we've been using Excel 2010 on a workstation and a Server ok. It's being run under some superuser domain account. (\\mydomain\mylovelySyperUser)
DCom Security and Launching User Tab is also configured for full permissions for this account.
All Permissions in Excel are given including:
Programmatic access to Visual Basic Project
Now when we me moved to a new Server it also runs, but it takes 40 seconds to 2 minutes to launch Excel programmatically. (under this domain account) and

If we Run Excel programmatically under local account (\\localServer\myLovelyUser) then it launches immediately BUT we're getting this error message while trying to run Macro:

Programmatic access to Visual Basic Project is not trusted

Please Help

Thank You

S

[3com]

http://support.microsoft.com/kb/282830/en-us

[sergioza]

http://support.microsoft.com/kb/282830/en-us

Thank You,
Unfortunately this doesn't apply

1. We're using Excel 2010

2. We had already enabled all Excel Secrurity permissions as specified in the link

S

[3com]

I think the problem and solution are not of the side of Excel.
It's probably a matter of setting the local server.
I guess your local server acts as Local Testing Server, if not possibly want to read this:

http://www.dwuser.com/education/cont...-how-to-do-it/

In this case, I think this would not be the right forum for you.

Anyway you can avoid receiving some alerts from Excel, with somethig like...

Sub ooo()
Application.DisplayAlerts = False
'Your code here
Application.DisplayAlerts = True
End Sub

Ignore that statement behaviour at server-level, but you can try...