Using VBA how do you print custom properties to an Excel spreadsheet?

[rivy1080]

Hello,

I'm new to the forum and Visio and hoping someone can help.

I have developed 3 custom properties for each shape that describes our work processes. Each work process is a file and we have 60+ processes. I am trying to send the custom properties and the file name to an Excel spreadsheet. I would like to use VBA so I can iterate through all the files in the directory and retrieve the information without having to manually open each file. I found a procedure that will process the files in a directory and I can get the file name, but am stumped on how to get the custom properties.

Thank you!!
rivy1080

 

[johnwm]

Hi and welcome to Tek-Tips. Please read faq222-2244 to get the best from these forums.

Because of the complicated nature of Visio's object model I normally use the Tools|Macros|Record New Macro menu. If you cannot actually record all that you need to achieve there is usually enough clues in the code to find out how to reference the object/property that you're looking for, and you can modify the code from there.

You've probably found the Object Model already, but if not it's here:

http://msdn.microsoft.com/library/d...Automation_and_the_Visio_object_model_118.asp

________________________________________________________________
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?'
Drive a Steam Roller

 

[rivy1080]

johnwm, thanks for your reply.

I tried to use the Tools|Macros|Record New Macro menu to get the code to use a custom report, but it would not record any of the steps. All I got was the name of the macro with no code. Would you have an idea of why that happened?

I had not looked at the Object Model. I'll take a look at it and see if I can understand it.

Thanks for the link,
rivy1080

 

[VisioMVP]

The Visio MVPs have a webpage of sample VBA code segments.

On the page are examples of looping through Visio files in a directory and sending custom properties to a text file.

http://visio.mvps.org/VBA.htm

John... Visio MVP - Visio.MVPs.org