How to search for a file using macro?

[ramkumarcn]

I am trying to design a macro to check for a file in a particular folder. the files may either be an excel file or a txt file. can you please help me with code?

 

[John Davis]

I am trying to design a macro to check for a file in a particular folder. the files may either be an excel file or a txt file. can you please help me with code?

Does this help?

http://www.excelguru.ca/node/30

 

[Kukaless]

I have a similar question about this topic.
I am looking to actually open up that folder to see if the file exists.
Here is what I’m trying to accomplish. I have a excel file that is populated with numbers in column A and column B.
Column A Column B
<TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.65pt; WIDTH: 211.6pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 width=282 border=0><TBODY><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 98pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" vAlign=bottom noWrap width=131>70209-82542-107 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>




</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 113.6pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=151>LHM7020982542107<o></o>




</TD></TR></TBODY></TABLE>
<o></o>
I need to do a search in an external folder for that number that’s in column B. This file will always be a PDF but could exist more than once in that folder. The files will always be in the same folder.
Search needs to be done in this directory.

sushrd01\departments\Qualassur\SCANNED RAW MAT'L CERTS\

Any help would be appreciated. I’m using Excel 2007.
Thanks