find a designated value in all workbooks in a designated folder

  • Thread starter Thread starter ctm
  • Start date Start date
C

ctm

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.
 
Thanks Ron,
I think that was the code i modified to use.
I will have a look at it on Monday.

Cheers


Corey....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
Possible ? Search all closed workbooks in a folder 1
Reference a workbook level named variable. 8
Save As and new workbook new name used in existing code 8
Cell values to an array, then array transpose to another workbook 8
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top