Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2012, 03:51 AM
RichardP RichardP is offline Inexplicable automation errors in Word and Excel Windows 7 32bit Inexplicable automation errors in Word and Excel Office 2010 32bit
Novice
Inexplicable automation errors in Word and Excel
 
Join Date: Apr 2012
Location: France 80%, UK 20%
Posts: 9
RichardP is on a distinguished road
Default Inexplicable automation errors in Word and Excel

Last night (15 August 2010) there were 20 Windows 7 updates. Since then all my macro-enabled documents in Word and Excel report automation errors (1004), even though I haven't changed the code for months!
Any ideas? Can an MVP help please? This is very urgent
Reply With Quote
  #2  
Old 08-16-2012, 05:27 AM
RichardP RichardP is offline Inexplicable automation errors in Word and Excel Windows 7 32bit Inexplicable automation errors in Word and Excel Office 2010 32bit
Novice
Inexplicable automation errors in Word and Excel
 
Join Date: Apr 2012
Location: France 80%, UK 20%
Posts: 9
RichardP is on a distinguished road
Default

After some online research, I solved this by (re?)registering mscomctl.ocx
regsvr32 C:\Windows\SysWOW64\MSCOMCTL.OCX

Go figure!
Reply With Quote
  #3  
Old 08-16-2012, 06:16 AM
Venky62 Venky62 is offline Inexplicable automation errors in Word and Excel Windows 7 64bit Inexplicable automation errors in Word and Excel Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

Interesting. Could you explain how you did this, in case some of us also run into this problem?
Reply With Quote
  #4  
Old 08-16-2012, 08:01 AM
RichardP RichardP is offline Inexplicable automation errors in Word and Excel Windows 7 64bit Inexplicable automation errors in Word and Excel Office 2010 32bit
Novice
Inexplicable automation errors in Word and Excel
 
Join Date: Apr 2012
Location: France 80%, UK 20%
Posts: 9
RichardP is on a distinguished road
Default Solved after finding this link

http://stackoverflow.com/questions/1...aused-by-forms

I simply registered the .ocx as I said in my previous post, i.e.
Start > Run
then regsvr32 C:\Windows\SysWOW64\MSCOMCTL.OCX

This is specific to 64-bit Windows 7 (running Office in 32-bit mode, the most common scenario)
For 32-bit WIndows, the equivalent would be:
regsvr32 c:\windows\system32\mscomctl.ocx

For some inexplicable reason, the Windows updates on Wednesday night (15/08/2012) must have unregistered this file
Reply With Quote
  #5  
Old 08-16-2012, 07:38 PM
macropod's Avatar
macropod macropod is offline Inexplicable automation errors in Word and Excel Windows 7 64bit Inexplicable automation errors in Word and Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Curious. I have the same setup (64-bit OS and 32-bit Office) and have encountered no problems.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Word-Excel stephen_pen Mail Merge 0 09-22-2011 05:17 PM
Inexplicable automation errors in Word and Excel Word, Excel automation Paul-NYS Office 3 06-29-2011 01:11 AM
Word 2003 Menu Errors BillK Word 0 05-12-2010 09:57 AM
What is Application Automation and How can I use it in VBA KramerJ Excel 0 03-30-2009 12:59 PM
COM Automation Errors ivanm Word 0 03-23-2009 07:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft