View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ctm ctm is offline
external usenet poster
 
Posts: 10
Default find a designated value in all workbooks in a designated folder

I did have a worksheet set up with vba to find a value in a particular
column in all workbooks in a set folder, but i must have deleted it somehow.

IF a value was found it copied the sheet in the workbook into the current
workbook for viewing.

Each workbook searched was closed after the search was carried out.

Can anyone assist me in this? I was sure there was code that done 99% of
this as is from a forum.

--

Regards
Corey