VBA Error Automation error.
 

Francisco,

Don't know for sure, but go to the VB Editor
Tools menu References
see if any are marked as missing.

If they are, uncheck them and try again.

steve

"Francisco J. Melendez" wrote in
message ...
We have a spreadsheet with macros developed internally.
The macro uses ole automation etc. The workbook functions
properly in all machines except for one, where we get
a "VBA Error: Automation error, Unspecified error" popup.
The user is clicking on a form button that clears a
predifined range. It works fine in all other machines.
Have run repair for Office, checked all patches are
installed. Same office configuration. No idea this does
not show in the knowledge base when i search for it. Alll
machines running windows 2000 and office 2000.