Excel/Visual Basic Compile Error

Posted on 2012-08-21
Last Modified: 2012-08-21
I wrote an Excel VBA program for my company and it has been used for over a year by 6 users, running Windows XP and Office 2007. 4 of the 6 users now receive a 'Compile Error:  Automation Error' when they move their cursor anywhere near (but not touching) a command button. The command button contains visual basic code that formats data on the excel sheet and retrieves data from a backoffice 'Universe' database.
When the error occurs, the program goes into debug mode and displays the subroutine
for the worksheet before doubleclick event.

We can't understand why this is only happening for some users using the same excel workbook.

Can somebody please point us in the right direction.

Thank You.
Question by:BENNYLAU
    LVL 44

    Accepted Solution

    register the Uniobjects.UnioaifCtrl ActiveX object.

    Author Closing Comment

    Reregistering Uniobjects did not fix the problem, but I thought that it could be that one of the other dlls that needed to be reregistered. 'Buyers' is a project that users here use to do their work.  It accesses the back office database via uniobjects, has planning and sales functions and creates excel reports amongst others. When 'Buyers' was reinstalled, it fixed the problem.

    Thank you for your help and in putting me in the right direction

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A list of useful business intelligence software.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now