Excel Workbook Data Extraction

The following will loop through the C:\Forum\ (change it to the directory you need) and run the code you need against all workbooks within that directory.

Please Login or Register  to view this content.

Hello MDBCT,

Thanks for your response. Unfortunately, this is sorta over my head, so would you have an example of how to insert code into Excel...to be more specific....an example of how to set up a workbook for extracting data from workbooks within another file?

Tommy

Extract files in the attached to a folder called Forum on your C:\drive. Move the one called "Move this one somewhere else.xls" to a different location such as your desktop. The macro, when run, will list the Excel files in the Forum directory as well as the contents of the A1 column of the first sheet in each workbook.
The code - I've highlight the new info.

Please Login or Register  to view this content.

MDBCT,

The extract operation worked fine! Thank you for your wonderful assistance!!

Tommy

Hello.

I'm back with a question regarding a previous question which had been solved. The previous question pertained to extracting data from excel workbooks located in a designated file; the data would extract to a workbook located in a different file.

My next questions pertains to extracting data from excel workbooks by specific columns; that is, I want to extract data from column B only in workbooks located in a designated file. The recipient file, located elsewhere, would populate data in column B, from all workbooks, located in the designated file.

The designated file will grow as additional workbooks will be added, and so, the recipient workbook would grow as well.

Any help would be greatly appreciated!

Thank you,

Tommy