VBA: Understanding VBA use when attaching an excel spreads

Hi all,

I am very much an amateur in this realm and would like to understand how I can possibly set up a macro that would save a worksheet, then copy it as an attachment to lotus notes??

The reason being is that I want to automate a form that is saved and then possibly sent to someone to approve.

Any advice would be greatly appreciated

Thanks very much, that has been a hell of a lot of help.

The code you gave me is great and works perfectly.

Just on the off chance how would suggest the best way of learning VBA to an advanced level.:)