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.
11 pekerja bebas membida secara purata $228 untuk pekerjaan ini
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.
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
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.