Many of the macros I use require a step where it copies information from a daily/weekly report to be copied into another workbook. These reports are downloaded from a web browser. Previously, chrome would download them all with the exact same name so it was easy to reference them in the code, however now it seems to be storing these and adding a number to the end.
Is there a way I can tell the macro to select a workbook containing a phrase? For example - any workbook named "Resolved Cases Report" regardless of if it is called "Resolved Cases Report (12)"
There would only be one version of the report open at any given time. I hope this makes sense