Sparx Enterprise Architect VBA macro

We have a requirement to create & update relationships between elements in Sparx Enterprise Architect. The relationships are captured in an Excel spreadsheet which lists the name of the element, type of element, the type of relationship, stereotype and the element it has relationship with.

The spreadsheet may also include GUIDs which are generated by Sparx when exporting elements. If these exists, these must be maintained as they specify the element to be updated as well as the preservation of hierarchy.

An Excel VBA is required to create and update relationships.

A user will specify the elements to be updated which will include the GUID. If no GUID exists, the module has to prompt the user whether they would like to create the new element. The user should be able to also specify "Apply to all elements" so that the user is not repeatedly ask to confirm the creation of a new element.

The Excel VBA module should call the API provided by Sparx. More information about Sparx can be found at [url removed, login to view]

The Excel VBA must work with Microsoft Excel 2003 and greater. Operating systems running Windows XP or greater must be supported.

Sample files are provided. More information can be provided should there be a need.

Please note that all code must be commented, must adhere security principles e.g. data sanitization and must be documented. The code must be easy to read and maintain. The code must be optimized and perform efficiently. The code must not employ calling third-party objects or components unless there is agreement from us. The code must also employ the appropriate validation. The code must be modular as to allow further development. The code must not be obfuscated or be protected by any password mechanisms. This is so that the code can be audited to deem that the project has been successfully completed.

Any information that is provided remains a property of ours and must remain confidential. All intellectual property, copyright, etc must be transferred to us at the end of the project. All code & documentation must be transferred to us. We also expect a warranty period of 3 months or longer should there be issues with the code.

Kemahiran: Excel, Visual Basic untuk Aplikasi

Lihat lagi: third party agreement sample, systems architect, property development spreadsheet, password vba project excel, password protected excel, need a architect, e enterprise, confidential agreement sample, an architect, sparx systems enterprise architect, sparx enterprise architect, microsoft vba, microsoft macro, microsoft excel VBA, excel vba or, enterprise architect sparx, end vba, code enterprise, architect com, vba e

Tentang Majikan:
( 0 ulasan ) Auckland, New Zealand

ID Projek: #5416009

11 pekerja bebas membida secara purata $228 untuk pekerjaan ini


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that I can start with the implementation.

$250 USD dalam 0 hari
(161 Ulasan)

A proposal has not yet been provided

$231 USD dalam 3 hari
(27 Ulasan)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Lagi

$222 USD dalam 3 hari
(27 Ulasan)

Hi, I have lots of experience with excel macros and vba. Just send me a sample or part of your file which you want to be transformed and I will give you results today.

$250 USD dalam 7 hari
(2 Ulasan)

Hello, One of my customers have named me Excel Guru. That I am not but I know very much about Excel and VBA. Please check my reviews, profile and portfolio and award me with trust. With regards, Tom

$250 USD dalam 10 hari
(4 Ulasan)

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$250 USD dalam 3 hari
(3 Ulasan)

A proposal has not yet been provided

$333 USD dalam 10 hari
(8 Ulasan)

A proposal has not yet been provided

$155 USD dalam 3 hari
(0 Ulasan)

A proposal has not yet been provided

$222 USD dalam 3 hari
(0 Ulasan)

I am ready to work on your Excel VBA Task as per the requirement ,message me before awarding . Lagi

$188 USD dalam 5 hari
(0 Ulasan)

A proposal has not yet been provided

$155 USD dalam 3 hari
(0 Ulasan)