Book a Demo

Author Topic: Excel VBA crash accessing Attribute.isID on a specific config  (Read 2998 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Excel VBA crash accessing Attribute.isID on a specific config
« on: August 08, 2019, 12:17:55 am »
I'm using an old version of Geert's Excel VBImporter to create classes & attributes that I customised to set the attributes ID (attribute.isID = true or false).
It works fine on my PC, yet it recently started to crash Excel when I run it in my client's environment (Win 7, EA 13.5, Excel 2013, no admin rights) i.e. it used to work everywhere.
Even displaying an existing attribute ID crashes it e.g. Debug.Print myAttribute.IsID

I tried Geert's latest 4.2 VBImporter and this time I'm getting an error instead of a crash when running the Class + Attribute import (no changes made):
Run-time error 2147417848 (800108108)
Automation error - The object invoked has disconnected from its clients

Reloading the EA project, I can see the new classes & attributes.

Note that I ran the test on a local EAP file.
I also added in the VBA macro Debug.Print myAttribute.IsID after creating the attribute and it crashes just before running that line.

Excel VB references have the right references enabled incl EA Object Model 2.10 and Ms Office 15.0 Object Library.

I ran out of ideas.

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com