Automation error

[Jennifer]

Hi,
I have a form i Built in VBA that I am trying to load on another computer.
I built it on 2003 and this comuter is running 2007. When the form loads i
get an automation error. I have never seen this can anyone help.

 

[Bob Flanagan]

In the Excel 2007 PC, press ALT-F11 to bring up the VB Editor. Then select
Tools, References and see if you have a missing reference. Try unchecking
the reference. If that solves, try unchecking the same reference on your
Excel 2003 build of the workbook.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel