Checking to see if an .exe file is loaded

[RLN]

Re: Access 2003

In my Access app I am needing to see if an .exe file is loaded locally
before running it.
The thing is it might be located somewhere ele other than the default
folder.

Does someone have a simple example using VBA code how to check for a
file to see if it is located in default folder "XYZ", and if it's not
there, how do you launch the dialog window (when doing a typical "File/
Open") so the user can locate the correct folder, than use that one to
check to see if the file is there?

many thanks...

[Tom van Stiphout]

Re: Checking to see if an .exe file is loaded

On Tue, 12 Feb 2008 07:10:34 -0800 (PST), RLN <rlntemp-gng@yahoo.com>
wrote:

You can check for existence using the Dir function. See help file.
The File/Open dialog is described here:

http://www.mvps.org/access/api/api0001.htm

And bookmark that site!

-Tom.

>Re: Access 2003
>
>In my Access app I am needing to see if an .exe file is loaded locally
>before running it.
>The thing is it might be located somewhere ele other than the default
>folder.
>
>Does someone have a simple example using VBA code how to check for a
>file to see if it is located in default folder "XYZ", and if it's not
>there, how do you launch the dialog window (when doing a typical "File/
>Open") so the user can locate the correct folder, than use that one to
>check to see if the file is there?
>
>many thanks...