Inventor General Discussion

Inventor General Discussion

Reply
Active Contributor
ivar.mo
Posts: 27
Registered: ‎01-19-2003
Message 1 of 7 (1,407 Views)
Accepted Solution

VBA error in Inventor 2012 after MS Office 2007 updates august 2012

1407 Views, 6 Replies
08-16-2012 02:07 AM

Hi!

My VBA macro buttons have stopped working today. They worked fine yesterday, before MS sent me a busload of updates (14 to be exact)- among them SP3 for Office 2007.

When I press any of my buttons nothing happens, but if I open VBA editor and try Debug - Compile, I get "Compile error: Automation error" on every instance referring to any form of Inventor "Document" like "DrawingDocument", "PartDocument" etc.

 

Anyone else seen this?

 

My system is a Win 7 Ultimate 64-bit, MS Office 2007, Inventor 2012

 

Appreciate any feedback!!

 

Best regards

Ivar B Mo

Fimtech AS

Norway

 

 

I solved my issue by following the advice found here:

http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3-0-caused-by-forms

 

For Windows 7 - remember to run cmd.exe "as administrator", and then:

 

for 32bit Windows systems:

regsvr32 -u c:\windows\system32\mscomctl.ocx

regsvr32 c:\windows\system32\mscomctl.ocx

 

for 64bit Windows systems:

regsvr32 -u c:\windows\syswow64\mscomctl.ocx

regsvr32 c:\windows\syswow64\mscomctl.ocx

 

Fixed my problems! :-)

 

 

 

Member
mvdijck
Posts: 4
Registered: ‎08-22-2012
Message 2 of 7 (1,318 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

08-22-2012 05:46 AM in reply to: ivar.mo

Same problem here:

 

AutoCad 2012, office 2007, Windows 7 64 bit Enterprise

 

problem after windows updates

Compile error

Active Contributor
ivar.mo
Posts: 27
Registered: ‎01-19-2003
Message 3 of 7 (1,298 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

08-23-2012 01:15 AM in reply to: ivar.mo

I solved my issue by following the advice found here:

http://stackoverflow.com/questions/11971358/excel-vba-automation-errors-due-to-office-service-pack-3...

 

For Windows 7 - remember to run cmd.exe "as administrator", and then:

 

for 32bit Windows systems:

regsvr32 -u c:\windows\system32\mscomctl.ocx

regsvr32 c:\windows\system32\mscomctl.ocx

 

for 64bit Windows systems:

regsvr32 -u c:\windows\syswow64\mscomctl.ocx

regsvr32 c:\windows\syswow64\mscomctl.ocx

 

Fixed my problems! :-)

 

 

 

Member
mvdijck
Posts: 4
Registered: ‎08-22-2012
Message 4 of 7 (1,291 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

08-23-2012 01:30 AM in reply to: ivar.mo

I solved it one workstation uninstall en reinstalled Office 2007.

I will try this ouhter solution on the outher workstations and let you know.

Member
mvdijck
Posts: 4
Registered: ‎08-22-2012
Message 5 of 7 (1,288 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

08-23-2012 01:46 AM in reply to: mvdijck

Worked for me :smileyhappy:

thanx Bether than reinstall office!

for 64bit Windows systems:

regsvr32 -u c:\windows\syswow64\mscomctl.ocx

regsvr32 c:\windows\syswow64\mscomctl.ocx

Member
mvdijck
Posts: 4
Registered: ‎08-22-2012
Message 6 of 7 (1,273 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

08-23-2012 04:40 AM in reply to: mvdijck

Installing office only works temporary After the updates the problem returns.

Distinguished Contributor
miechh
Posts: 143
Registered: ‎07-09-2008
Message 7 of 7 (828 Views)

Re: VBA error in Inventor 2012 after MS Office 2007 updates august 2012

01-10-2013 02:25 AM in reply to: ivar.mo

Second time in two weeks I had to apply this work-around of de-registering and re-registering the OCX's... Those stupid Office-updates...:smileyfrustrated:

 

Made a batch-file with the given DOS-commands so I don't have to type the commands in the DOS-prompt everytime MS Office comes with updates...

Product Design Suite 2014
Inventor 2014, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.