| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find a designated value in all workbooks in a designated folder
Maybe example 4
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ctm" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find a designated value in all workbooks in a designated folder
Thanks Ron,
I think that was the code i modified to use. I will have a look at it on Monday. Cheers Corey.... "Ron de Bruin" wrote in message ... Maybe example 4 http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ctm" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| only count designated rows | Excel Discussion (Misc queries) | |||
| Looking up a value next to a designated cell | Excel Discussion (Misc queries) | |||
| Designated a cell as a name range | Excel Programming | |||
| Count designated cells | Excel Worksheet Functions | |||
| Delete all rows with designated word | Excel Programming | |||
Linear Mode
