• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Inventor

    Reply
    Active Contributor
    Posts: 27
    Registered: ‎01-19-2003
    Accepted Solution

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

    884 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

     

     

    Please use plain text.
    Member
    Posts: 4
    Registered: ‎08-22-2012

    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

    Please use plain text.
    Active Contributor
    Posts: 27
    Registered: ‎01-19-2003

    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! :-)

     

     

     

    Please use plain text.
    Member
    Posts: 4
    Registered: ‎08-22-2012

    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.

    Please use plain text.
    Member
    Posts: 4
    Registered: ‎08-22-2012

    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

    Please use plain text.
    Member
    Posts: 4
    Registered: ‎08-22-2012

    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.

    Please use plain text.
    Valued Contributor
    Posts: 94
    Registered: ‎07-09-2008

    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 2012
    Inventor 2012 SP2, Vault 2012
    HP Workstation Z220
    Intel Xeon 3.4GHz
    16GB RAM
    Nvidia Quadro 4000
    Windows 7 Professional (64bit)
    Please use plain text.