Macro for exporting sheet with formulas stripped and also filename with days date

[Svenski79]

Hi all,

Apologies if this code already exists somewhere else on the forum.

I need a VBA macro that will pull a single sheet (let's call it Sheet1) from a speadsheet and attach it to an email with the days date in the filename DDMMYY. Wondering if this is possible and also if possible, the formulas wouldnt be included in the attachment but the cell colouring/bordering etc would be.

Thanks in advance and all the best for the week ahead.

[AlphaFrog]

Try this link...

Mail one sheet

[Svenski79]

Awesome, thanks I'll give it a shot.