Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If texbox value begins with "E" then send to another sheet. aintlifegrand79 Excel Programming 1 February 13th 08 10:45 PM
Signature missing when "send to" "mail recipient" Jim Tortorelli Excel Discussion (Misc queries) 2 September 21st 07 05:19 PM
How do I cancel the "Send this Sheet" option? John @ Spray Excel Discussion (Misc queries) 1 January 31st 07 07:35 PM
VB code to "Send To" Multi addresses muzzas news Excel Programming 2 February 18th 05 01:12 PM
Annoying "virus" alert when using code to send mail steve Excel Programming 5 October 29th 03 05:28 AM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"