N
Nigel
I have a template xlt file containing a VBA code module, this is opened,
data is added under the control of another workbook and the new workbook is
saved under a new name. No problems so far.
The new workbook is subsequently opended and the code contained in the
module, originating from the template, is run which includes some code to
email the workbook to a number of recipients. Now comes the question.
I wish to remove the module from the workbook before it is emailed. Since
the removal of the module, the one running the email routine, is the module
in question can this be done?
TIA
Cheers
Nigel
data is added under the control of another workbook and the new workbook is
saved under a new name. No problems so far.
The new workbook is subsequently opended and the code contained in the
module, originating from the template, is run which includes some code to
email the workbook to a number of recipients. Now comes the question.
I wish to remove the module from the workbook before it is emailed. Since
the removal of the module, the one running the email routine, is the module
in question can this be done?
TIA
Cheers
Nigel