There are two possibilities that may be occurring

1) There is an error trapping setting in VBA that may be set diferent
on the one PC

VBA menu - Tools - Options - General - Error Trapping


2) When a new version of Office is installed on a PC where Ofice is
already installed sometimes the references don't get updated properly
and you have to manually fix the problem. You have to go to the VBA
menu Tools - Reference. first make sure all the references are the
same. Next if you get any errors when running the macro you may need to
go back to the reference menu and Browse for the library. The different
versions of Office is installed in you Program files Folder under
microsoft Office. the different versions of office are in a sub folder

1) 2002 - Office 10
2) 2003 - Office 11
3) 2007 - Office 12
4) 2010 - Office 13 (not sure if this is correct since I haven't used
2010)


When the new version of office is installed sometimes the reference
libraries don't get updated and point to the latest version of office.
When a new version of office is installed the older libraries are
removed. so one of you refernce library pointers may be point to a file
that doesn't exist. I'm not usre why this happens but I've seen this
problem occur often.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=206232

http://www.thecodecage.com/forumz