Link to home
Start Free TrialLog in
Avatar of alevin16
alevin16Flag for United States of America

asked on

Access Runtime and Excel 2003 VBA

Hello All

I have an odd issue here.  I am not even sure if it is an issue because a user is claiming their Excel VBA stopped working EXACTLY when I installed Access 2013 runtime.  I have learned that "sometimes" users are not correct :D (Hey but who knows, he might be right)

I installed Access 2013 runtime on all the computers here so that the users can run an Access database.  One user, who uses Excel 2003 and has created many controls with VBA/macro code behind them, now cannot activate any of the controls.  Buttons that used to click and produce a result now will not click (it is as if they are not even there).  When he tries to put in another object (like another command button) it will not allow him to insert the object.

I did some looking and I found something dealing with a Microsoft patch that knocks out the VBA/macros.  I deleted the exd files but it still does not work for him.

Could Access 2013 runtime have effected Excel 2003?  I have uninstalled Office 2003 and put it back on as well as uninstalling Access 2013 runtime and reinstalling.  Same error.

Any ideas?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of alevin16

ASKER

Hey All

Thanks for the comments.  I did install only the 32bit runtime (in fact when I accidentally tried to install the 64 bit, by clicking on the wrong downloaded file, the computer yelled at me).

Repairing did not help.  I tried that first and it still had the error.  

One other thing I just tried, I copied one of the excel spreadsheets that he was using onto my computer.  I have office 2013 full version.  I was able to open and run he macros/vba code.  It seems to only effect the office 2003 users (I wish I could update those machines but they are connected to very specific machines that can only be controlled with a computer running office 2003).

I will try to get some screenshots so maybe that could help.

Thank you all very much again!
Andy
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello Boyd

we actually restored the computer using an image we took before we ever installed Access 2013.  The computer worked fine.  It seems that after Access runtime is installed whatever it effected stays effected.

I am going to try restoring another computer and then put Access 2007 runtime (is there even such a thing? :)  )   I don' think my program will work though without at least access 2010 runtime.

I'll keep everyone posted.

Thanks for the ideas!
Andy
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.