Excel to vss and vss to Excel. Newbee.

[Fabian]

Hi all there,

I'm new with Visio developement. I use for my job Visio 2000 SP2
enterprise. I wonder whether there is an easy way/software tool to
convert an Excel sheet (with a predefined format) into a Vss stencil
and viceversa.

Many thanks.
Fabian

 

[David Parker]

The database wizard has the ability to create masters from a table, such as
Excel spreadsheet.
It may be what you want.

 

[Fabian]

The database wizard has the ability to create masters from a table, such as
Excel spreadsheet.
It may be what you want.

Fantastic David, that's exactly what I wanted: it was so easy...but if
you do not know....

However, with the wizard, a little thing does not work as I wanted.

I would like to be able to import also the "Prompt" field (master
properties) into the Visio Masters that I create with the wizard. I
also noted that the "Name" field (always master properties) is the
primary Key of the db table I define with the wizard, but the Prompt
field remains the standard template one.
How can I import the Prompt field from a database? it is not in the
listed cellsheet of the wizard.

Many thanks.

Cheers,
Stefania

 

[David Parker]

Er, yes, it seems that the Prompt, Keywords, etc are copied from the source
master
You could do a little (VBA) code to loop thru the masters to update their
labels...

BTW, be careful not to have the Visio VBA editor open when you save your new
stencil, otherwise it will be saved with VBA code in it, even if there
really isn't any. Therefore, I sometimes automate this kind of code from
Access or Excel VBA because I have the data in that application.