Inventor General

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

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

1246 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
Posts: 4
Registered: ‎08-22-2012
Message 2 of 7 (1,158 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
Posts: 27
Registered: ‎01-19-2003
Message 3 of 7 (1,136 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
Posts: 4
Registered: ‎08-22-2012
Message 4 of 7 (1,131 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
Posts: 4
Registered: ‎08-22-2012
Message 5 of 7 (1,128 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
Posts: 4
Registered: ‎08-22-2012
Message 6 of 7 (1,113 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
Posts: 131
Registered: ‎07-09-2008
Message 7 of 7 (667 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)

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you interested in helping shape the Autodesk Community?
We’re looking at a few different ways to improve the “All Forums” landing page and need your feedback! If interested, please take a few minutes to fill out the following Usability Study. Thank you for your time!

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube