Automate shape report


Joined
Oct 13, 2015
Messages
3
Reaction score
0
Hello

I am trying to have a user click a button and a report will be generated from selected shapes.

Set vsoSelect = Visio.ActiveWindow.Selection ' How many selected shapes do we have?
For Each vsoShape In vsoSelect
Visio.Application.Addons("VisRpt").Run ("C:\Users\tom\Documents\ReportDefinition_2.vrd / rptOutput=EXCEL")
Next

This works. Can I direct the report output to a specific Excel file or do I have to live with what the report gives me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top