Jaymond Flurrie
Well-known Member
- Joined
- Sep 22, 2008
- Messages
- 919
- Office Version
- 365
- Platform
- Windows
I'm working on my thesis and it makes a workbook to which it saves results to.
Once I have driven the code, I get those results and I go to check those and occasionally forget to activate the main workbook, even if I'm editing code in the main workbook's modules.
The question now is that how could I ensure that how my main workbook is active when I drive code from there? In some C# it would be something like "this.workbook.activate", but how does it go with VBA?
I change the name of my main workbook daily (so that I have some backups). That prevents from hard-coding the name of workbook to the code.
Once I have driven the code, I get those results and I go to check those and occasionally forget to activate the main workbook, even if I'm editing code in the main workbook's modules.
The question now is that how could I ensure that how my main workbook is active when I drive code from there? In some C# it would be something like "this.workbook.activate", but how does it go with VBA?
I change the name of my main workbook daily (so that I have some backups). That prevents from hard-coding the name of workbook to the code.