Re: $$Excel-Macros$$ How to send mail with excel

Hi, http://www.rondebruin.nl/sendmail.htm http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx#odc_thesendmail20utility Try the other links with other options available in the sites Regards Santosh On Wed, Mar 30,

RE: $$Excel-Macros$$ Fwd: Need Help

Hi, Paste this macro in the first workbook. Open it manually and run the “Test” macro. Sub test() Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range Const strPath As String = "D:\Donnees\Daniel\mpfe\Prathima R\" 'to be modified Dim inCalculationMode As Integer Application.ScreenUp

Re: $$Excel-Macros$$ Fwd: A sheet which will capture time along with name of Agents along with work assign for them.

thank u so much ranjan u have provide me solution exactly what i wanted heartiest thanks to u. Thanks, Prabhat On Mon, Apr 4, 2011 at 7:42 AM, rajan verma wrote: > Hi Prabhat, > is it what you want.. find the attahced File > > Rajan > > > On Sun, Apr 3, 2011 at 6:32 PM, Born to Win wrote: > >> >

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

thank you everyone On Mon, Apr 4, 2011 at 5:01 PM, Raghunandan wrote: > Gr8 goin > > > On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha wrote: > >> Ashish, You are doing such a tremendous job...Keep going Bro. >> >> regards, >> Mrinal >> >> On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote: >>

$$Excel-Macros$$ SQL Server Group

Dear All, I want SQL Server Group something like our excel-macros group. Can anyone send me the links.. Thanks in Advance.. *Best Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ - Pivot table .Calculation = xlPercentOfColumn

Hi Members, Could you tell me where I should put the .Calculation = xlPercentOfColumn .NumberFormat = "0.00%" to get desired results 'Define fields in PivotTable With PT ' Reference to Exisiting Pivot Table With .PivotFields("HHSizeGroup") .Orientation = xlRowField

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Gr8 goin On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha wrote: > Ashish, You are doing such a tremendous job...Keep going Bro. > > regards, > Mrinal > > On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Ashish Koul has been selected as 'Most Helpful Member' for the

Re: $$Excel-Macros$$ Excel help

i think mr. bhanu needs "000999" tobe "999" not "00999" On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ wrote: > if your data in a1 type the below formula on anywhere in the same worksheet > =IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1) > -- > *Thanks & Regards > Thamu > * > > --