checking for file in CONDITION

H

HX

I used to use the following as a condition in a macro -- if the filename
wasn't found, the macro ended. Is this method of looking for a file no
longer supported? I pulled up this old code to use in a new situation, and
the program keeps giving me an error:

Condition:

Dir("c:\sd_data\sdc" & Format$(Date(),"yyyymmdd") & ".txt")=""


Error:

The expression you entered has a function name that [my program name] can't
find.

Help?!

Access 2003 PE SP2

Thanks!
 

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

Macro Condition 2007 1
A Report, based on query, called from macro is prompting for param 1
Prompting for Criteria already defined in Report/Query. 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Condition - cant parse expression 1
Macro Code for bringing up Save As dialog box and changing file Type 0
Syntax Where Condition in Macro 1
Export a table to text file with file name depending on certain da 7

Top