Visio Pro 2003 Trial: Accessing/Manipulating "Database Properties" in VBA

[Beowulf]

I've done a fair bit of googling on this topic and only found 2 URLs
neither of which address this issue. Is there really no way to
programmatically manipulate the information that shows up in the
"Database Properties" window for a shape in a Database Modeling
diagram?

If it is possible, what version of Visio would I have to actually buy?

 

[Al Edlund]

AFAIK not all of the properties in database modeling are available
programmatically. They are stored internally in the add-on. What are you
trying to reach out and touch?
Al

 

[Beowulf]

AFAIK not all of the properties in database modeling are available
programmatically. They are stored internally in the add-on. What are you
trying to reach out and touch?
Al

I'd like to be able to both:
1. programmatically generate new entities and create attributes,
primary keys and relationships for them
2. programmatically read a diagram and output the entities,
attributes, relationships, etc. into a Word document or Excel
spreadsheet.

 

[David Esiobu]

I'd like to be able to both:

1. programmatically generate new entities and create attributes,

primary keys and relationships for them

2. programmatically read a diagram and output the entities,

attributes, relationships, etc. into a Word document or Excel



"You claimed all this time that you would die for me.

Why, then, are you so surprised when you hear your own eulogy?"

- Tool, "Eulogy"

I'm trying to do the same, particularly #2. Any help on this would be
appreciated.

I apologize for posting in .developer.vba before seeing this.

 

[Mike Ishimitsu[MSFT]]

The website http://www.pdata.com/VME/VisioModelingEngine.htm may provide you with more detail as to what you can and cannot do
programmatically with Visio's database modeling engine.

--
Mike
Visual Studio Enterprise Frameworks and Tools

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they
originated.
--------------------
From: "Al Edlund" <[email protected]>
Subject: Re: Visio Pro 2003 Trial: Accessing/Manipulating "Database Properties" in VBA
Date: Fri, 21 May 2004 09:49:15 -0500

AFAIK not all of the properties in database modeling are available
programmatically. They are stored internally in the add-on. What are you
trying to reach out and touch?
Al

 

[Beowulf]

The website http://www.pdata.com/VME/VisioModelingEngine.htm may provide you with more
detail as to what you can and cannot do programmatically with Visio's database modeling engine.

I've already visited that website several times. The problem is that
I don't have this modeling engine installed on my machine. What
version of Visio would I need to get access to that object hierarchy.

(Incidentally, that URL returns "Cannot find server or DNS Error" at
the moment.)

 

[David Esiobu]

The website http://www.pdata.com/VME/VisioModelingEngine.htm may provide

you with more detail as to what you can and cannot do

programmatically with Visio's database modeling engine.

--
Mike
Visual Studio Enterprise Frameworks and Tools

This posting is provided "AS IS" with no warranties, and confers no

rights. Use of included script samples are subject to the terms

specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this

message are best directed to the newsgroup/thread from which they

originated.
--------------------
From: "Al Edlund" <[email protected]>
Subject: Re: Visio Pro 2003 Trial: Accessing/Manipulating "Database Properties" in VBA
Date: Fri, 21 May 2004 09:49:15 -0500

AFAIK not all of the properties in database modeling are available
programmatically. They are stored internally in the add-on. What are you
trying to reach out and touch?
Al

Many thanks. That's exactly what I needed.

Beowulf: Try refreshing, or going directly to /VME/ . Also, your project
will have to reference "Microsoft Visio Database Modeling Engine Type
Library" to use the API.

- David

 

[Beowulf]

you with more detail as to what you can and cannot do

Many thanks. That's exactly what I needed.

Beowulf: Try refreshing, or going directly to /VME/ .

Thanks. As it turns out, the IT department was monkeying around with
the T1 line connecting my building to my company's main campus (and
the internet), so that explains the issues I had with finding
pdata.com. It's there today.

Also, your project
will have to reference "Microsoft Visio Database Modeling Engine Type
Library" to use the API.

Thanks for that information. After browsing through the References
list I found the proper library. My assumption was that the VME would
automatically be included in a project created in Visio's VB Editor.
Now, I get to go play around with the type library.

 

[gerard_klein]

Beowulf,

Can you please give me some sample code, for the library

Thanks in advance

Gerard

(e-mail address removed)

 

[Gerard A. Klein]

I am working on a VBA program to export a Er diagram directly to a MySQL
database. In that way I can design a database with visio a generate it
directly in MySQL.


The VME engine is badly documented and I cannot find any good examples on
how to access fields, properties etc. Can you please provide me with some
more code examples. It would be very helpfull.



I will share my final code with you of course.



Thanks in advance for your help



Kind regards,



Met vriendelijke groet,



Gerard Klein