Messages

1

General Board / Re: Creating clickable links in generated documents

« on: January 20, 2023, 11:44:38 pm »

Thanks for your reply, Geert.
By the way, previously, I've used your excellent Excel macros for exchanging data between Excel and Sparx.
I'm not sure what you've suggested is exactly what I'm looking for. On our site, we frequently embed links to external web sites (for example, the web site for an organisation or a government department) within the text of the notes of an entity, such as an organisational actor. When this text gets produce in generated document from a template into a Word document, can we get these links to be clickable links within the generated Word document?
Regards
Pete

2

General Board / Creating clickable links in generated documents

« on: January 20, 2023, 03:10:38 am »

Hi.
I was wondering if any of you knowledgeable people can help me.
In EA Sparx (v15.2) we have notes in entities which get listed out in generated docs. These links often contain url links. Is there any way to make these links clickable in the generated docs? unfortunately <a>url</a> doesn't seem to work

Thanks
Pete

3

Suggestions and Requests / Re: vbscript date conversion

« on: February 26, 2021, 02:33:36 am »

Thanks Geert

It was a stupid problem, but I'd been stuck on it for a while.

I've used your Excel sparx tool extensively in the past and I love it.

Pete

4

Suggestions and Requests / Re: Compare diagrams - gap analysis

« on: February 26, 2021, 12:57:44 am »

The best way I can think of is to (for example, for entities), in a script, list all the entities from diagram A to a csv file. List all entities from diagram B using same script. Load both lists side by side into Excel, sort each list, then you can compare. If you are good at scripting, you can automate some of the manual bits.

5

Suggestions and Requests / vbscript date conversion

« on: February 26, 2021, 12:52:49 am »

Hi

Very simple request, but I've not been able to find any help on this online.

How do you convert a date to a string, please?

Any help, gratefully appreciated.

Pete