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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. adeel
    Replies:
    0
    Views:
    1,211
    adeel
    Nov 4, 2011
  2. patwran

    visio 10 shape area calculation

    patwran, Nov 7, 2012, in forum: Visio
    Replies:
    0
    Views:
    872
    patwran
    Nov 7, 2012
  3. simpilot2000
    Replies:
    1
    Views:
    658
    simpilot2000
    Sep 9, 2013
  4. ale71mosca
    Replies:
    0
    Views:
    311
    ale71mosca
    Apr 1, 2014
  5. LarryG-AIA
    Replies:
    0
    Views:
    1,152
    LarryG-AIA
    May 30, 2014
  6. C Yiu

    Remove a shape from a layer

    C Yiu, Jul 7, 2014, in forum: Visio
    Replies:
    0
    Views:
    566
    C Yiu
    Jul 7, 2014
  7. Ilan Bar
    Replies:
    0
    Views:
    323
    Ilan Bar
    Aug 13, 2015
  8. leica
    Replies:
    1
    Views:
    416
    slhn2010
    Feb 25, 2016
Loading...