running visio report from macro

[kashif afzaal]

Visio comes with some predefined reports, what i want to do is to run those report from a context menu (by right clicking on the white space). I know how to add menu items in context menu and assign it to ceratin procedure and function. What i dont know is how to run a report when i click on something on the context menu item. DOes anybody know how to do this

T.I.A

 

[Bill K. [MSFT]]

Add this formula to the action cell (modify the report name and output
accordingly):
RUNADDONWARGS("VisRpt","/rptDefName=DoorSchd.vrd /rptOutput=EXCEL_SHAPE")

For an example, open a copy of the "Walls, Shell and Structure" stencil ,
edit the "Door Schedule" master and you will find this formula in the
ShapeSheet's "EventDrop" cell.


Hope this helps,
--
Bill K.
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Visio comes with some predefined reports, what i want to do is to run

those report from a context menu (by right clicking on the white space). I
know how to add menu items in context menu and assign it to ceratin
procedure and function. What i dont know is how to run a report when i click
on something on the context menu item. DOes anybody know how to do this?