Inventor General Discussion

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

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

1343 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,254 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,234 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,227 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,224 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,209 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 (764 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 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 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