running visio report from macro again

[Norek]

I found answer to this question (RUNADDONWARGS
"VisRpt","/rptDefName=DoorSchd.vrd /rptOutput=EXCEL_SHAPE") but when i
want to generate raport in excel workbook not in the shape ( i tried
many strange solutions :/ ) it still doesn't working, maby somone know
the solution or have the list of arguments to the VisRpt
("Reporter.exe")

Thnx for any help

 

[Norek]

I found new options /rptActionRun= /rptActionUpdate= /rptUpdate= but
still nothing :/



Norek napisal(a):

 

[Norek]

I found solution ( simple but working ) :

Attach vba library

VBA.SendKeys ("{Enter}") ' send enter to the dialog box when appear
and its working
Visio.Addons("VisRpt").Run ("/rptDefName=yourraport.vrd
/rptOutput=excel")


Best wishes
Norcio


Norek napisal(a):

 

[Scott]

Norek,

Where did you find a list of parameters (/rptOutput, etc.) for the report
addon? I'd love to know if there are others; in particular, when I automate
an XML report I'd like to suppress display of the resulting xml file.

Thanks --

 

[David Parker]

I have asked the dev team at Microsoft, and the one mentioned below is the
only one that you can use.

However, my upcoming book will include examples of how you can include
advanced filtering in the report definition directly, as the user interface
hides this option.

 

[David Parker]

Scott,
Only the button was removed ... the filters can still be created in XML
Notepad or just Notepad.