Imput box

Question:

I have used a imput box to name a saved worksheet in a file folder.

Can the same imput be used to rename a worksheet and then attach it to a email?

Yes It can be done..
I know only the rename part...

you can use savecopyas method to save a copy with name in inputbox...

but to email the same ...

I think you have to record the macro by doing so manually ..
and then tweak the code... as desired...



Don't forget to click *

Any suggestions as to how to attach to email