D
dead_girl
Hi Ryan,
Thank you kindly for your reply.
That extra bit of code (in red) was added after creating my initia
macro, which was running without error until the extra code was added.
Hence, I believe it is that extra bit of code (in red for closing th
workbook) that is the cause of the error message.
In any case, he way I've done it seems to be a bit cumbersome:
1. I select the workbook which contains the macro and make it th
active workbook
2. Then close the active workbook (ie. the workbook which contains th
macro that I've made the active workbook by step 1.)
Are there any other elegant ways of doing this simple task
Thank you kindly for your reply.
That extra bit of code (in red) was added after creating my initia
macro, which was running without error until the extra code was added.
Hence, I believe it is that extra bit of code (in red for closing th
workbook) that is the cause of the error message.
In any case, he way I've done it seems to be a bit cumbersome:
1. I select the workbook which contains the macro and make it th
active workbook
2. Then close the active workbook (ie. the workbook which contains th
macro that I've made the active workbook by step 1.)
Are there any other elegant ways of doing this simple task