how can i read visio's datadictionary using VBA?

[hbfi92]

Hello,

im using visio 2002 and i want to store shape data in a sql database. I want to create a database table like: shape(section, row, cell, value).

What i want to know is:
a) Is it possible to read visio's datadictionary (where all information about shape sheets must be stored) using vba?
b) There seems to be no cells() object for iterating through all cells of a shape object. How can i get all informations about section, rows and cells without knowing cell names?
e.g
for each objCell in objCells
debug.print objCell.Name
next
c) Does anyone know the source code of the "database export assistant"? Where can i get this code or information about the code?

thanks for help
hbfi92

 

[johnwm]

All info for every shape is stored in the ShapeSheets. To get started do a search on this forum for 'Cells'. I have given a few starters on this recently:

thread172-936286
thread172-853777
thread172-623083

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[hbfi92]

Hi johnwm, thank you for your help.

Maybe I described my problem not precisely. I want that a shape object says me: which properties it (the shape object) has (summary and used properties). I don’t want to point the cells by their name or index.
I got a list with indexes of sections, rows and cells from msdn. But I want to generate such a list reading the properties of a shape object. Like the “database export assistant” does.
This is the reason why I asked for the vba code of this assistant.

Are there any ideas?

Thank you
Hbfi92