Inventor General Discussion

Inventor General Discussion

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

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

1371 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

 

 

Member
mvdijck
Posts: 4
Registered: ‎08-22-2012
Message 2 of 7 (1,282 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,262 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,255 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,252 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,237 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: 139
Registered: ‎07-09-2008
Message 7 of 7 (792 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)
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

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