Automate Org Chart Wizard

[sqluser]

I have an sqr which produces a report of a company tree. Normally I would
have to open Viso and point it to the txt file created by the report.

I want to find out if it is possible to automatically launch the wizard with
the necessary file name from code (a macro or vba or vbscript, etc). If it is
possible, can any one give me some pointers?

Nik

 

[Mike Mueller [MSFT]]

You might start here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvisio02/html/vsOChrt.asp

This article was written for Visio 2002 but is applicable to Visio 2003 as
well.

 

[sqluser]

Thanks Mike. I've gone through the article, but I'm still unclear abt some
things. It talks about running the prog (_Organization Chart Wizard.exe) from
command line. I saw another microosft article which refers to the prog as
OrgWiz.exe. I don't know which of the names is correct. Even at that, I tried
both names but I got an error that it couldn't locate the prog, so I'm
wondering do I have to be in Visio directory to run this?

 

[Mike Mueller [MSFT]]

In Visio 2003, the file is named Orgwiz.exe and is located in \Program
Files\Microsoft Office\Visio11\DLL. Unless your command window has this
directory in the path you will beed to invoke the exe using a fully
qualified path.