File Exists?

[uby]

Hello!

I have a workbook that looks for information in a "Source File". Within this source file there are files for each month. They are saved by month and year (mm-yy.xls). If that month does not exist, I want it to skip looking for the files and continue the procedure.

Is there a way to do this?


Thanks in advance!

Uby

 

[PHV]

Take a look at the Dir function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[uby]

Thanks so much for your help!