It sounds as though one or more libraries are missing, maybe through
uninstalling custom components. Open Excel, get past the errors, then
go into your vb editor and under Tools, References, select the
following three libraries and unselect any others that are listed.

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
Microsoft Office 10.0 Object Library


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=274653