Interfacing Access and Visio

[Nuthin]

I am trying to use a Macro in Access 2K to start Visio 2K and open a
particular file. Unfortunately, I do not know how to program in either VB
or SQL. Can it be done? I can get the Visio program to open using RunApp,
but the subsequent SendKeys are going to Access and not Visio. HELP!

Nathan

 

[Steve Schapel]

Nathan,

SendKeys is seldom a good option. Include the path and name of the
Visio file in the Command Line argument of the RunApp macro action. It
will look like this...
"C:\Program Files\Office\Visio.exe" "C:\PathToFile\YourFile.vsd"