M
Mr. Wizard
I have a Visio drawing created from a text file with custom properties
already populated. The problem is that the database used to generate the
text file does not populate one of the fields completely, and I am left
manually cutting and pasting hundreds of times for the information that the
database cuts short.
I have an Excel spreadsheet with a complete text string to fill this field
and a unique identifier that matches another field commpn to the Visio shape.
I would like to set up a macro to compares the unique identifier field in
Visio to the table in Excel and replaces the text.
Does anyone have an elegant approach to this in VBA?
I can already get the list of properties in VBA in Visio, and I can program
an Excel file to do the comparison.
already populated. The problem is that the database used to generate the
text file does not populate one of the fields completely, and I am left
manually cutting and pasting hundreds of times for the information that the
database cuts short.
I have an Excel spreadsheet with a complete text string to fill this field
and a unique identifier that matches another field commpn to the Visio shape.
I would like to set up a macro to compares the unique identifier field in
Visio to the table in Excel and replaces the text.
Does anyone have an elegant approach to this in VBA?
I can already get the list of properties in VBA in Visio, and I can program
an Excel file to do the comparison.