ExcelBanter - code of "send this sheet"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - code of "send this sheet" (https://www.excelbanter.com/excel-programming/406836-code-send-sheet.html)

song.zhang

code of "send this sheet"

I need to know what's the VBA code of "send this sheet" in EXCEL.
I could not use "record the macro" to get the code,
The Object "worksheet" didnot have the email related method.

Ron de Bruin

code of "send this sheet"

Hi song.zhang

See
http://www.rondebruin.nl/mail/folder3/mail2.htm

--

Ron de Bruin
http://www.rondebruin.nl/tips.htm

"song.zhang" schreef in bericht ...
I need to know what's the VBA code of "send this sheet" in EXCEL.
I could not use "record the macro" to get the code,
The Object "worksheet" didnot have the email related method.

All times are GMT +1. The time now is 02:58 PM.