Tim_Excel_
Well-known Member
- Joined
- Jul 12, 2016
- Messages
- 512
Hi Forum,
I just can't get my head around this.
Whenever I open the file I have been working on, it is opened as Macros. The code in this workbook refers to this name, which is essential. However, when my colleague opens the very same file I sent to him, it opens up as Macros.xlsm. Now this interferes with the code, as the code only looks for the name Macros and not Macros.xlsm. Does anyone know how this happens and how to work around it?
ask me any questions if you need to
I just can't get my head around this.
Whenever I open the file I have been working on, it is opened as Macros. The code in this workbook refers to this name, which is essential. However, when my colleague opens the very same file I sent to him, it opens up as Macros.xlsm. Now this interferes with the code, as the code only looks for the name Macros and not Macros.xlsm. Does anyone know how this happens and how to work around it?
ask me any questions if you need to