VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

**nanjingwoodworking** · 10-07-2013, 05:32 PM

Hi,

I want to do loop in a folder of many excel files.

For each excel files, I want to loop through a tab and search a name of tab.

In the tab of worksheet I found, I want to find row that has certain title and copy this row to another file with all the return values.

Thank you.

Nanjing

**tigeravatar** · 10-07-2013, 05:56 PM

Nanjing,

Welcome to the forum!
Here's some generic and commented code that should get you started:

Please Login or Register  to view this content.

**nanjingwoodworking** · 10-07-2013, 06:37 PM

Compile error
Method or data member not found.
I am using Excel 2010.

wsData.Find(strTitle , x1Values, x1Part)

**tigeravatar** · 10-07-2013, 07:20 PM

Those should be the letter L, not the number 1:
xlValues, xlPart

not
x1Values, x1Part

Please Login or Register  to view this content.

VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Re: VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Re: VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Re: VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop through multiple files, run macro, then save as Excel workbook in a different folder

[SOLVED] loop through files in a folder based on partial name from worksheet cell

Loop between 2 files in a folder

loop through all files in a folder except for one of them

Loop through files in a folder

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions