Run-time error '1004': Programmatic access to VB is not trusted

[Layman]

Hi!

Here's the situation

My XLA is constantly requesting data from a server via an XLL, an
writing the data onto a work sheet.

After happily churning out data for roughly 1/2 the day, Excel crashe
with Run-time error '1004', Programmatic Access to VB is not trusted
The data received from the server is fine however, and if it's bee
working for 1/2 the day, it shouldn't be a security issue! (Securit
level set to Low in any case)

Right after we get the run-time error, we receive the dreade
"EXCEL.exe has generated errors and will be closed by Windows", an
Excel terminates.

I have tested this on Office XP, and Office 2000 with similar result
(Office 2000 does not include the runtime error, but still gives th
application error), and different machines.

The app itself has passed through QA, and many end users use it withou
complaints.

The system resources are more than enough, and the event viewer doe
not reveal anything suspicious.

This has been going on every day for 2 weeks now!

HELP!?? Thanks

 

[Dave Peterson]

It sounds like your code also does something to the project.

And xl2002 added an option for users to allow access to VB.

Tools|macro|Security|Trusted Sources Tab.

there's a check mark that you can add (near the bottom).

This isn't changeable via code--it helps prevent the proliferation of malicious
code.

 

[Layman]

Interesting.. thanks!

We were able to replicate this problem on a local machine, and settin
the Trust Sources seems to have done the trick.

I am still mystified as to why this problem would suddenly kick in i
the middle of the day. After querying some end users some more, i
appears that they all receive this error when they switch workbook
(i.e click on another workbook)

 

[Dave Peterson]

It sounds like there's a "helpful" macro that needs to be updated.