Processing xls files sequentially

Gday all,

I use Excel 2003 at work, and 2007 at home. The wife is crook today, so im working from home... well, trying to. I have searched the net for a solution to my particular prob, but while I am ok with developing and running some macro's, im not really a power user.

Problem:
I understand that Application.FileSearch has been depreciated in 2007, but I cannot seem to modify other suggested codes to make workarounds work with my needs. Im hoping someone here can help

I have a folder with a many .xls files in it, all ending in "*metrics33yrs.xls", my 2003 code (sourced from the net) opens each one sequentially (1st part of below code), copies given cells, and pastes them into a separate workbook (2nd part of below code).

Can anyone please help with the first part of the code so that it works in 2007?

Cheers in advance

Please Login or Register  to view this content.

Welcome to the forum, Bjornago.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

FileSearch isn't deprecated in 2007, it's gone. Puzzling.

This isn't fully cooked yet, but let me know how you get on.

Please Login or Register  to view this content.

It REQUIRES a reference to Microsoft Scripting Runtime.

Please Login or Register  to view this content.

will return a variant that is either Empty or contains a list of found files.

Like this:

Please Login or Register  to view this content.