hi Andy, personal opinion aja nih ...
Kalau cuma mau save & send by email, kok kayaknya malah ngeberatin worksheet aja yah kalau mau pakai macro... padahal XL sudah menyediakan tools yg ga ribet deh ... save : 1. tekan tombol Ctrl & S bersamaan atau 2. click tombol bergambar disket dibawah menu bar dipojok kiri atas send file by email : click File, pilih Send To, pilih Mail Recipient thanks ranzbebek.blogspot.com ----- Original Message ----- From: abimono To: [email protected] Sent: Tuesday, June 10, 2008 10:49 AM Subject: Re: ]] XL-mania [[ save dan send via email otomatis hai Andy syntax pendeknya: sub aaaa() Application.DisplayAlerts = False ActiveWorkbook.Save ActiveWorkbook.SendMail "[EMAIL PROTECTED]", "test" end sub yang panjangnya ada di : http://groups.yahoo.com/group/XL-mania/message/4704 attachmentnya bisa dilihat di mirrornya [mail-archive] 2008/6/9 Andy Kristian (PSPE) <[EMAIL PROTECTED]>: Halo.. minta tolong nih… Saya mau membuat file excel yang begitu di klik satu tombol (atau cell) akan langsung mensave dan mengirim file tersebut lewat email. Bisa nggak ya?? Terima kasih -- - abimono - _________________________________________________________________________ http://www.abimono.com
<<image001.gif>>
