Re: To suppress message box
You could try trapping the error and then simply resuming when the error occurs.
Try using:
On Error Resume Next
Re: To suppress message box
If you craete your project as ActiveX exe you can check option 'Unattended execution'. I believe that will supress msg boxes
Unattended Execution
Located on the General tab, this property can be set for code components that have no user interaction. In an ActiveX DLL project, this makes the DLL thread-safe (via Apartment-model threading).
In an ActiveX EXE project, it allows the component to be multithreaded. The implications and limitations of this property are discussed in "Building Code Components."
Note Components that contain UserDocuments, UserControls, and forms cannot be marked for Unattended Execution.
Iouri Boutchkine
[email protected]