D
dhowell
I have a Visio 2003 flowchart drawing template that users will utilize
to answer a series of questions.
I have these questions set up in the form of shapes with custom
properties.
I want to have these answers output to an Excel spreadsheet with the
following format:
Where......
CP = custom property title
CPV = custom property value
column1 column2
CP1 CPV1
CP2 CPV2
CP3 CPV3
CP4 CPV4
etc......
I tried to use the "Reports...." feature, to do this, but found that
that by default the output was:
column1 column2 column3 etc......
CP1 CP2 CP3
CPV1 CPV2 CPV3
I know that I could do a macro in Excel to rearrange and format the
data, but I don't wan't this to be something the users have to do......
Any guidance or suggestions on how to get the output clean to begin
with would be appreciated.
Doug
to answer a series of questions.
I have these questions set up in the form of shapes with custom
properties.
I want to have these answers output to an Excel spreadsheet with the
following format:
Where......
CP = custom property title
CPV = custom property value
column1 column2
CP1 CPV1
CP2 CPV2
CP3 CPV3
CP4 CPV4
etc......
I tried to use the "Reports...." feature, to do this, but found that
that by default the output was:
column1 column2 column3 etc......
CP1 CP2 CP3
CPV1 CPV2 CPV3
I know that I could do a macro in Excel to rearrange and format the
data, but I don't wan't this to be something the users have to do......
Any guidance or suggestions on how to get the output clean to begin
with would be appreciated.
Doug