Automate shape report

Discussion in 'Visio' started by JayEnn, Oct 16, 2015.

  1. JayEnn

    JayEnn

    Joined:
    Oct 13, 2015
    Messages:
    3
    Likes Received:
    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?
     
    JayEnn, Oct 16, 2015
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.