Automation Error

Solved
CCM_lfrt Posted messages 3 Status Member -  
 Paola -
Hello,
If anyone has the solution to my problem, I would be infinitely grateful to them for sharing the solution with me. I have searched extensively but cannot find an answer. Here is the problem.
I upgraded from OFFICE 2010 to OFFICE 2016.
In Excel, all my old Macros work without any problem.
In WORD, all my Macros result in an "Automation Error" message.
Thank you in advance for your suggestions.
Louis

Configuration: Windows / Chrome 58.0.3029.81

2 answers

m@rina Posted messages 27391 Registration date   Status Moderator Last intervention   11 561
 
Hello,

There may be a few VBA functions that don't work when moving from 2010 to 2016, not many but enough to cause issues.

Take a closer look at ActiveX and form controls in particular. I remember having problems with ActiveX controls that were no longer recognized. It was enough to recreate them.

m@rina

--
Beware of herbal tea: it’s a dangerous poison...
1
CCM_lfrt Posted messages 3 Status Member
 
I am infinitely grateful to you. Following your recommendation, I simply exported a macro containing an ActiveX to a file, then (re)imported this file into VBA, and all the macros (about ten) worked correctly.
And to think that I spent hours trying other recommendations without success.
Thanks again,
LL
0
Paola
 

It worked for me too!!!

Thank you so much.

0