Excel VBA -- Compile Error:Automation Error RRS feed

  • Question

  • I wrote an Excel VBA program for my company that has been utilized for about a year with over 350 users, all running Windows XP and Office 2007. A handful of users who receive a new laptop (same as mine), have experienced a "Compile Error: Automation Error" when they attempt to run the program. There are no error codes, and the compile error points to a procedure declaration that compiles fine on other PCs: "Public Function KeyFound(strKey As String, SourceCollection As Collection) As Boolean". I have commented out the procude only to get another compile error at a different procedure. I checked for missing references and found none; I have disabled any Add-Ins; I tried to delete all .EXD files; nothing works. One user reinstalled Office and got the program to run, another, needed to have IT rebuild his laptop and got it to work. I need to find the problem so I don't have to keep having users rebuild their laptops. Any help would be greatly appreciated.
    Thursday, April 26, 2012 3:23 PM

All replies