ChrisFoster
Active Member
- Joined
- Jun 21, 2019
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi all,
I expect this is fairly simple.
I have a large amount of code, but I'm stuck at this particular point.
The code will activate different workbooks at certain points but they are all have static filenames apart from one of them. For the one that isnt static the one constant is always "- All Clients". So for example;
April 2020 - All Clients
May 2020 - All Clients
June 2020 - All Clients
Is there a one line of code I can use to open the workbook that is like ...- All Clients?
It will be the only workbook open that has a name like this so it can't be confused anywhere.
Cheers
Chris
I expect this is fairly simple.
I have a large amount of code, but I'm stuck at this particular point.
The code will activate different workbooks at certain points but they are all have static filenames apart from one of them. For the one that isnt static the one constant is always "- All Clients". So for example;
April 2020 - All Clients
May 2020 - All Clients
June 2020 - All Clients
Is there a one line of code I can use to open the workbook that is like ...- All Clients?
It will be the only workbook open that has a name like this so it can't be confused anywhere.
Cheers
Chris