VBA Error 5416

[adminpsp]

Hi,

We get the VBA exectution error 5416 when we try to execute the following:

MsgBox Application.Options.SaveInterval
Application.Options.SaveInterval = 0

or

Application.ActiveWindow.View.ShowBookmarks = False

We work on Terminal Server 2003 on an x64 machine with Office 2007 GPO
applied. The last command listed here is not GPO modified.

This error is no viewed on a standalone workstation (no GPO and Windows XP
x86).

Any idea ?
Thanks

 

[Jonathan West]

On the Terminal Server machine, do you have multiple users simultaneously
accessing the same template containing the code?

I have occasionally found that VBA code misbahaves in odd ways when
templates are subject to concurrent access. I've no idea why it happoens and
no way of predicting when lightning will strike. All I can say is that I
have seen it on occasion, and after investigation the problem was repeatable
and the cause was clear.

It should be an easy enough thing for you to check. If it turns out that
this is the cause, the answer is to plece a copy of the template or add-in
in each user's profile rather than relying on a common shared copy.

 

[adminpsp]

Hi,
Thanks for response. We see this behaviour even if we do the trick in the
user templates, which are personnal.

The vb code is launched from a third party Delphi application via ole
automation. Developer has no idea reagarding the error because it works on
standard workstations.

Another point, is that despite this error the parameter is changed. (This
word parameter is the automatic saving process)