Need to open all files of a certain name using wildcard for folder for month

**BillDoor** · 01-08-2013, 05:05 AM

Hi

I want a macro that will open a certain named file in each of 12 folders labeled with the month.

e.g C:\folder\January\MI.xlsx and C:\folder\February\MI.xlsx, etc, etc

I have the following code, which I tried to modify to get this to work, but it seems to be missing something

Please Login or Register  to view this content.

Can anyone see what I am missing here please?

thanks

**smuzoen** · 01-08-2013, 05:56 AM

The method you are using above is more for iterating through a folder however "theDate" is not a valid function - perhaps you mean "Date". If I understand you question there is just one file you want to open however it is present in 12 different folders (Jan-Feb). So to do what you are asking

Please Login or Register  to view this content.

Need to open all files of a certain name using wildcard for folder for month

LinkBack

Thread Tools

Rate This Thread

Display

Need to open all files of a certain name using wildcard for folder for month

Re: Need to open all files of a certain name using wildcard for folder for month

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions