How to check for the existence of a file in an access macro?

R

Rli

i want to find out how i can stop an access-macro if a certain file does not
exist on my computer...
can anyone help me ?
 
N

Nikos Yannacopoulos

What you need is a condition like:

Dir("C:\SomeFolder\SomeFile.ext")=""

on a StopMacro action.

The Dir looks for the file and returns its name if found, or "" if not,
in which case the StopMacro will execute.

HTH,
Nikos
 
R

Rli

thanks, Nikos....its the right awnser...

Nikos Yannacopoulos said:
What you need is a condition like:

Dir("C:\SomeFolder\SomeFile.ext")=""

on a StopMacro action.

The Dir looks for the file and returns its name if found, or "" if not,
in which case the StopMacro will execute.

HTH,
Nikos
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Append Crosstab Query to Existing Table 0
VBA word change keys 0
Autonumber field in Excel that behaves the same as Access 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Macro to select and delete levels of a document 2
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Office365 Family + TXT or MX Domain 0

Top