My macro currently pulls the data I need out of a workbook "week of 7-21 to 7-27.xlsx". I want it to look to pull the data from any workbook that has a similar name (i.e. "week of **-** to **-**.xlsx).
Here is the code I have:
Any help would be appreciated.Please Login or Register to view this content.
Thank you.
Bookmarks