VBA to Open Multiple Excel Files

[nrxanders]

I have a question regarding a macro that will search a drive for all excel files that start with a given character(s), open that file and pull data from a given tab, close it, and continue the search until all data has been successfully pulled and stored. Any help or suggestions would be great.

Thanks,

[Leith Ross]

Hello nrxanders,

Welcome to the Forum!

Do you really mean search the drive and all the follders and subfolders on the drive or just search the drive as a single directory, like "C:\".

[nrxanders]

Thanks!

Sorry for the confusion, I did mean search all of the folders and sub-folders.

[Leith Ross]

Hello nrxanders,

there are 2 macros. One is complete and the other is not. The macro to recursively find all files on a drive is finished. The second macro opens the Excel workbooks (.xls or .xlsx), However the code to to retrieve the data and store it is missing. you didn't post that information and I didn't request it. So, you can either add that code or tell me what data you need and where it it will be saved.

Macro to Recursively List Files

Please Login or Register  to view this content.

Macro (incomplete) to Open and Save the Workbook Data

Please Login or Register  to view this content.