By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,453 Members | 932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,453 IT Pros & Developers. It's quick & easy.

Checking to see if an .exe file is loaded

P: n/a
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...
Feb 12 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 12 Feb 2008 07:10:34 -0800 (PST), RLN <rl*********@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...
Feb 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.