find a designated value in all workbooks in a designated folder

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.
 
C

ctm

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

Possible ? Search all closed workbooks in a folder 1
Copy cell value from one worksheet to matching worksheet in another workbook 4
VBA code for pasting links -- modifying RDB code for summary workbook 10
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Macro for all Excel Workbooks to print to PDF 2
Import multiple workbooks to current workbook in specified row number 0
Cell values to an array, then array transpose to another workbook 8
Copy Insert Paste into all Workbooks in Folder 10

Top