Re: Calling Excel & Access from inside a CL.

Michael,

Something like that WILL work - we do it all the time, although sometimes it

takes a little experimentation to get it working just right. For example, we
open PDFs using Acrobat Reader, and the challenge there is that each new
version of Reader gets
installed in a new directory, so we actually had to write a VB program to
look around for it before opening it.

Generally speaking, a far simpler approach is to let the OS pick the
executable for you (including the path to it). If you just execute "start "
followed by the name of the file you want to open, Windows will check the
registry for the default program and launch it for you. This works for most
any type file, including PDF's, Excel, Word, HTML, etc. The START command
in Windows has many options, try "start /?" from a command prompt to review
them.

For Access databases, you may want additional command line options such as
/runtime to force it open in runtime mode, or various other options.

Doug