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
> 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.