Book a Demo

Author Topic: Access Sparx EA 13.5 from Visual Basic 2017?  (Read 7332 times)

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Access Sparx EA 13.5 from Visual Basic 2017?
« on: April 16, 2018, 07:19:29 pm »
Hi Guys!

I am trying do the same thing as  "Access Sparx Ea from Visual Basic" by Robert Glover Jr but with EA 13.5.
I made it with EA 12.1.1230, but with 13.5 I don't.

https://uloz.to/!OEkAqM6Von7X/sparx13-4-errorvs2017-png

I am trying to create Word 2016 Add-In for importing diagram element and update them. With EA 12.1 it works perfectly :)

Thanx for advice.

Mick


« Last Edit: April 16, 2018, 07:24:04 pm by m2i7c9k »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #1 on: April 16, 2018, 07:54:20 pm »
Mick,

It would help if you posted the actual error message.
In the image you posted it is too blurry.

Geert

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #2 on: April 16, 2018, 08:06:30 pm »
Hi Greet,

here are warnings:

Warning   #1
IDE0006   
Error encountered while loading the project. Some project features, such as full solution analysis
for the failed project and projects that depend on it, have been disabled.   
WordAddIn_EA13      1   Active


Warning   #2   
The referenced component 'EA' could not be found.   
WordAddIn_EA13         


Warning   #3   
Cannot find wrapper assembly for type library "EA".
Verify that (1) the COM component is registered correctly and (2) your target platform is the same as the bitness of the COM component.
For example, if the COM component is 32-bit, your target platform must not be 64-bit.   
WordAddIn_EA13   


I deregistered /registered EA.EXE


Thanx a lot 4 help :)

Mick

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #3 on: April 16, 2018, 09:11:11 pm »
EA is 32 bit, so that is something to take into account.

In this (old post) http://sparxsystems.com/forums/smf/index.php?topic=5268.0 I suggested to the EA.tlb. Have you tried that?

Geert

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #4 on: April 16, 2018, 09:22:18 pm »
Yes, I did. Without any effect. [My project >> Open >> Compile >> Target CPU:x86] if is it that?

Under References is: <The system can not find the reference specified>
It's a little confusing because I found EA.tlb and browse it. And I seeing it in Solution Explorer
with little yellow examination symbol.


Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #5 on: April 16, 2018, 09:28:42 pm »
I'm not sure what is wrong here.
Have you tried first removing it and then reselecting it?
In a C# project you have to reference the Interop.EA.dll, maybe that works for VB as well?

I've only used VBA (from within Word or Excel) and C# recently.
The last time I did a VB project for EA was in 2005 :/

Geert

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #6 on: April 16, 2018, 09:38:15 pm »
Have you tried first removing it and then reselecting it? = Yes.
In a C# project  = Same :/

I've only used VBA (from within Word or Excel) and C# recently... Yes I know, I learn from your VBA code, and the other posts here,
and from EA books...

And I have working Add-In based on Visual Studio 2018 [VB] + EA 12.1.1230, and it works fine but 13.5 and also BEAT 14 not working :/

anyway, thank U 4 your time

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #7 on: May 10, 2018, 07:20:29 pm »
For .NET projects you should be referencing Interop.EA.dll, not EA.tlb.

Thanx 4 Sprax support from Aaron Bell.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #8 on: May 10, 2018, 07:31:45 pm »
For .NET projects you should be referencing Interop.EA.dll, not EA.tlb.


Wasn't that exactly what I posted? ???

Geert

m2i7c9k

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #9 on: May 10, 2018, 08:31:23 pm »
Dear Greet,

Yes, you did! My appology, I was blind :)
Once again thank you too.

Mick

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Access Sparx EA 13.5 from Visual Basic 2017?
« Reply #10 on: May 10, 2018, 08:40:45 pm »
Dear Greet,

Yes, you did! My appology, I was blind :)
Once again thank you too.

Mick
No worries  :D