VBA Error on save due to Windows Security Warning

[Rx_]

VBA Error fail on Top method of Application (Excel)

New Question: has anyone else had this error?

I just updated the question because the problem was not what I expected.

This code never had an error when running the front end from a workstation linked to the exact same back end database.

After checking my home made error log, it became apparant that this error was randomlly happening over the last month, about once per week with different users. The same users could run again and get the Excel report created with out any errors.

The vba code causing the error shown in the next reply is:
2990 ObjXL.Application.Left = 4
3000 ObjXL.Application.Top = -7.25

Running this from a network location sometimes errored.
Running a copy of the same Access front end from a workstation never errored.

Wondering if anyone has an explanation?

 

[Rx_]

How should I deal with an intermittent error for Excel VBA?
My Database user and error logging - sorry not to check this sooner. This changes the error. On the error the err.description log shows:
Method 'Left' of object '_Application' failed
The uses (column hidden in attachment for protection) have sometimes come across this but never reported it. The users run this Excel VBA report about once a week.
If I run this from the network, it may or may not fail. If I run it from my desktop, it never fails.
An Internet search turned up something like this error:
http://www.excelforum.com/excel-programming/746724-method-width-of-object-plotarea-failed.html
It appears that the problem was caused when things got busy for the automation server.
My homemade error log indicates this happens randomly. Today, it is somewhat but not exactly consistant.

Any ideas on the best way to address this are appreciated.