Using vbYes or If statement
The line that changes is part of a Set WB = Workbooks.Add C:...
this is a workbook that considers an email list.
This is used to send emails.
I had thought of using the msgbox with vbYes and vbNo but I need 3
options, not 2. Hence the If crtieria, seems a better option.
The trouble is the 'Set' issue as it is not a piece of code that I
thought does anything, it needs to be part of something else.
Yes calling up a different macro I don't feel is handy as I don't wish
to tweak three lots of code, I'd rather tweak the one set, as apart
from one line the macros are all the same.
|