CaterinaAnna
Board Regular
- Joined
- Jun 15, 2009
- Messages
- 85
Sorry, another simple question from a novice ...
I want to use the name of an active workbook as a string later in a piece of code, but can't get the right syntax to find it and set it as a variable.
Name = ThisWorkbook.Name doesn't work because the code is in a different, master workbook and I don't really want to copy it to each individual book I want to process.
Thanks in advance for any help
I want to use the name of an active workbook as a string later in a piece of code, but can't get the right syntax to find it and set it as a variable.
Name = ThisWorkbook.Name doesn't work because the code is in a different, master workbook and I don't really want to copy it to each individual book I want to process.
Thanks in advance for any help