Hello,

I am trying to built a code which will send an email via Gmail with attachment. The attachment will be the temp file which is created with new name.

However I am getting Type mismatch or File is being used by another process error in the below code:

HTML Code: 

Please help me to attach the wb2 excel sheet.
Also if somebody could help me with the input box it will be great.

If the input box is cancelled the code should end.

Thanks,

Ketan