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

Hi abxy

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

Search in Google
http://groups.google.com/advanced_gr...=group:*Excel*

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





--
Regards Ron de Bruin
http://www.rondebruin.nl


"abxy " wrote in message ...
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 forum
search, so here goes...

i'm making a user form where upon initializing, i want it to search the
path: "R:\Walk in Reports" for an .xls document whose name is today's
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 how
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/

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

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