Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

6 REPLIES 6
SOLVED
Reply
Message 1 of 7
ivar.mo
1905 Views, 6 Replies

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

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

 

 

6 REPLIES 6
Message 2 of 7
mvdijck
in reply to: ivar.mo

Same problem here:

 

AutoCad 2012, office 2007, Windows 7 64 bit Enterprise

 

problem after windows updates

Compile error

Message 3 of 7
ivar.mo
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! 🙂

 

 

 

Message 4 of 7
mvdijck
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.

Message 5 of 7
mvdijck
in reply to: mvdijck

Worked for me 🙂

thanx Bether than reinstall office!

for 64bit Windows systems:

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

regsvr32 c:\windows\syswow64\mscomctl.ocx

Message 6 of 7
mvdijck
in reply to: mvdijck

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

Message 7 of 7
miechh
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...Smiley Frustrated

 

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 2024
Inventor 2024 (v 28.20.27200.0000), Vault Basic 2024
Fusion 360
HP Workstation Z4
Intel Xeon 3.4GHz
32GB RAM
Windows 10 Professional (64bit)

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report