Seach for value, select entire row, copy
Closed
Chasee57
-
Dec 20, 2011 at 11:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2011 at 03:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2011 at 03:13 PM
Related:
- Seach for value, select entire row, copy
- Vba select case like - Guide
- Saints row 2 cheats - Guide
- Reboot and select proper boot device - Laptop Forum
- How to delete a row in a table in word - Guide
- How to select at the rate in laptop - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 27, 2011 at 03:13 PM
Dec 27, 2011 at 03:13 PM
from what i understood from you question, you need to do use logic of both macro into a new one
from the first one, get the logic to find all the workbook
In the part of the first macro where it starts scanning the each workbook, make a call to use other macro
Since you would perhaps not like to be asked for each file what to search for, take out that part from 2nd macro and move it to the new maco
so it becomes some thing like
1. code to get what to be searched
2. get all the workbook
3. open a new workbook
4. loop through all workbook obtained in step 2 and call macro2
from the first one, get the logic to find all the workbook
In the part of the first macro where it starts scanning the each workbook, make a call to use other macro
Since you would perhaps not like to be asked for each file what to search for, take out that part from 2nd macro and move it to the new maco
so it becomes some thing like
1. code to get what to be searched
2. get all the workbook
3. open a new workbook
4. loop through all workbook obtained in step 2 and call macro2