[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel/Visual Basic Compile Error

Posted on 2012-08-21
Medium Priority
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 46

Accepted Solution

aikimark earned 2000 total points
ID: 38318095
register the Uniobjects.UnioaifCtrl ActiveX object.

Author Closing Comment

ID: 38318752
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are like me and like multiple layers of protection, read on!
Have you ever run into that annoying problem where the computer won't boot?  Wouldn't it be great if you had a tool that would make that disk boot again?  I have found one tool that works more often than not ...
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

834 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