Detecting If An .xls File Exist

[abxy]

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 :

 

[Ron de Bruin]

Hi abxy

I don't answer it but tell you how to find your answer

Search in Google
http://groups.google.com/advanced_group_search?q=group:*Excel*

Or use My Add-in
http://www.rondebruin.nl/Google.htm

 

[abxy]

Well, after a more extensive search I found 'this
(http://www.excelforum.com/showthread.php?s=&threadid=217011) threa
that gave me the help I needed....Thanks Tom