PC Review


Reply
Thread Tools Rate Thread

code of "send this sheet"

 
 
song.zhang
Guest
Posts: n/a
 
      28th Feb 2008
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 With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      28th Feb 2008
Hi song.zhang

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

--

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


"song.zhang" <(E-Mail Removed)> schreef in bericht news:F90F58D5-A91B-4C4F-96E1-(E-Mail Removed)...
>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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Field Names: "LongName", "ShortName", "Code", "Description","Comments" PeteCresswell Microsoft Access 2 25th Feb 2009 11:41 PM
Prevent code in "Sheet Activate" from running when sheet made visible from other macr Simon Lloyd Microsoft Excel Programming 10 21st Jun 2006 09:15 AM
Re: Method "Display" of object "mailitem" failed -2147221441 (80040107) when running code in background, code works when stepping through Carol Chisholm Microsoft Outlook VBA Programming 1 6th Sep 2005 03:22 PM
Removing "Send this Sheet" heading from Excel Bob Benjamin Microsoft Excel Discussion 7 11th Jan 2004 12:58 PM
Re: Possible to jump from "sheet 1" to "sheet 2" etc. via a code? Bernard Liengme Microsoft Excel Worksheet Functions 1 29th Aug 2003 03:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:23 AM.