Creating new identiccal workbook and emailing

[Pasha81]

Hi, I have a workbook with several sheets- lets call it MyWorkbook (The VBA Project should be locked so no one can view code). What I need is to run a code from MyWorkbook to make a copy of this – call it NewWorkbook. Now in NewWorkbook I need to hide sheets Kong,Bong and Dong……then save it as ‘Workbook name’& Date & time. Then email NewWorkbook. (I don’t want to keep any copy of NewWorkbook)

After that I need to Save MyWorkbook (so basically MyWorkbook keeps getting updated with new info everyday, and there are no hidden sheets)
VBA Codes should be password protected in both workbooks.

I tried to write the email code , this is what I have so far…….

Please advise

Thanks

Please Login or Register  to view this content.

[JeanRage]

Hi,

All the solutions you can dream of are available ... thanks to Ron ...
http://www.rondebruin.nl/sendmail.htm

HTH

[Pasha81]

thanks Jean
I found one that I could adjust to make this work