Hello again everyone,

ok, I know this has probably been answered many a time in this forum
but I just can't find the threads to answer my question using the foru
search, so here goes...

i'm making a user form where upon initializing, i want it to search th
path: "R:\Walk in Reports" for an .xls document whose name is today'
date in the format "mm dd yy". if the document exist, It'll open it.

The only problem i'm having is that i don't know how to code in VBA ho
to search a path to detect if a certain file exist...how do I do that?

Thnx for helping, it's greatly appreciated :

--
Message posted from http://www.ExcelForum.com