Hey all
I would like to know how by VBA code I can copy the Active sheet to a new Excel file - the file name will be a combination of cells A2 and A3 and A4 in another sheet called for example TEST
And attaching the new file as a new email ..
Hope for your help friends
I would like to know how by VBA code I can copy the Active sheet to a new Excel file - the file name will be a combination of cells A2 and A3 and A4 in another sheet called for example TEST
And attaching the new file as a new email ..
Hope for your help friends