View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FrigidDigit FrigidDigit is offline
external usenet poster
 
Posts: 21
Default Look for a string in filenames in a folder?

Hi all,

I have a spreadsheet in which I track invoices received from contractors.

I am trying to create a vba routine that will be triggered from a button to
search certain folders and subfolders for filename containing 2 strings.
Based on the results I will then populate and format certain cells. I have
no idea where to start. Could someone point me i9n the direction of some
code that i could work with?

Thank you very much