Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

ted this !!!   -- Regards Subu mail_to_s...@yahoo.com From: bpascal123 To: excel-macros@googlegroups.com Cc: Subu S Sent: Friday, 28 December 2012, 5:12 Subject: Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA I

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

r -> tools -> References  Thanks in advance for your help  -- Regards Subu mail_to_s...@yahoo.com From: bpascal123 To: excel-macros@googlegroups.com Cc: "aks.sharm...@gmail.com" ; Subu S Sent: Wednesday, 26 December 2012, 23:56 Subject:

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

am requesting a way to e mail these letters  I shall answer your other suggestion to change the VBA in the next mail    -- Regards Subu mail_to_s...@yahoo.com From: bpascal123 To: excel-macros@googlegroups.com Sent: Wednesday, 26 December 2012, 23:38

Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to customers using VBA

Dunning letter = Are these Printed forms where numbers were filled manually ?? Answer =  Manual forms and snail mail was approx 15+ years so , NOT now  Dunning or reminder is done thru E mail now   -- Regards Subu mail_to_s...@yahoo.com From: bpascal123

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

  the rest is up to you to choose and  tell me to do / follow    -- Regards Subu mail_to_s...@yahoo.com From: Anoop K Sharma To: excel-macros@googlegroups.com Sent: Monday, 24 December 2012, 10:00 Subject: Re: $$Excel-Macros$$ Mail merge and E mail

$$Excel-Macros$$ hi!

check this out http://msnbc.msn.com-report4.us/jobs/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell

Thanks a Ton David Works like a charm   -- Regards Subu From: David Grugeon To: excel-macros@googlegroups.com Sent: Sunday, 27 May 2012, 1:02 Subject: Re: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell

$$Excel-Macros$$ any spread sheet to get P/E, P/BV, P/S, ROCE etc data for Indian stocks ?

websites...but can't exactly figure out where thanks in advance & Regards Subu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

$$Excel-Macros$$ How to automate copy from sheet to sheet, wait for data upload and copy results again ?

how it is copied is NOT important. *Overwriting should be avoided* 4. Move to next symbol on sheet "Inputs". Copy the (next symbol) to cell c2 of sheet Input Dashboard 5. Wait for sp sheet to calculate (auto calculate) data 6. Copy second results t

Re: $$Excel-Macros$$ Grouping and average price calculation

one line (one line per company) and variances (or different priced ones) on different lines Is that possible Thanks in advance and Best regards Subu On Jan 24, 5:05 pm, ayush jain wrote: > Hi Sandip, > > It is better to use a pivot tables than a macro to group the information. &g

$$Excel-Macros$$ What is the HsTbar ?

Hi When I open a new spread sheet I see a module called HStbar.xls I have NOT created this What is this ? how is this created ? Any pointers would be much appreciated Regards Subu

$$Excel-Macros$$ Assigning different passwords to different cells

s" options available under the Protection menu of excel 2002 & above. Just wanted know if anything is possible on version less than 2002. I remember seeing a mail few days ago but unable to retrieve the same :((. Can anyone please help me with t

$$Excel-Macros$$ Re: Insert and name sheets based on data on a column

Hi Thanks for this automation, code Is this code password protected ? If so could you please give me the password or paste the VBA code here ? so that I can use it in other sheets as well TIA regards Subu On Sep 11, 10:27 pm, Dilip Pandey wrote: > Hi Subu, > > Attached workbook

$$Excel-Macros$$ Re: How to remove an add in

Thanks a ton Regards Subu On Sep 9, 7:56 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Subu, > > 1. Close all excel applications. > 2. Go to this folder - "C:\Documents and Settings\ > \Application Data\Microsoft\AddIns" > 3. Delete the file(add-in) from

$$Excel-Macros$$ How to remove an add in

with that add in. How do I do that ? Thanks in advance regards Subu --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Fre

$$Excel-Macros$$ VBA / Macro to Download pages listed on a column

Regards Subu --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel

$$Excel-Macros$$ Re: Insert and name sheets based on data on a column

Amazing.just amazing what is available here & the help from the Gurus Thanks !! best regards Subu On Sep 8, 5:09 pm, "Mudassar Ramzan" wrote: > Use attached Adds-On > > Regards, > > Mudassar Ramzan > > ----- Original Message - > From: "Sub

$$Excel-Macros$$ Insert and name sheets based on data on a column

Regards Subu --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel

Re: Fw: $$Excel-Macros$$ Convert PDF to Excel (-PIN-)

here ? Thanks in advance Best regards Subu On Aug 20, 8:07 pm, "Mudassar Ramzan" wrote: > Dear Subu, > > Download the cracked version. > > http://rapidshare.com/files/239495412/Able2Extract_1_.Professional.v6... > > Thanks & regards, > > || Mudassar Ramzan |

$$Excel-Macros$$ Re: How to use sheet names in formulae ?

Thanks Martin Initially I struggled with this...but now got the hang of it.. Best regards Subu On Aug 20, 1:02 am, gasparovicm wrote: > Hello, > You can use INDIRECT function, something like > INDIRECT(CONCATENATE(A4;"!$A:$A")) > instead of > KESORAMIND!$A:$A > t

$$Excel-Macros$$ Convert PDF to Excel (-PIN-)

Dear Mudassar and others The version in the link below is a TRIAL version and NOT a pro version... Do you or someone have the Pro version ? or is there a free ware somewhere for PDF to XL ? regards subu On Jun 1, 6:09 pm, "Mudassar Ramzan" wrote: > Dear All! >

$$Excel-Macros$$ Re: Help with Indian Stock market updater

Any developments / help on this query ? Thanks in Adv Regards Subu On Aug 18, 11:48 am, Subu wrote: > Dear members and Ashish Jain > > Good morning. > > With reference to the thread below > > 1. I tried to download this xl sheet > fromhttp://groups.google.com/group

$$Excel-Macros$$ Help with Indian Stock market updater

sheet. 3. Could you please share the same 4. Further the PE ratios and some important ratios are not get updated. Any idea how to get the PE ratio ? Thanks in advance and best regards Subu On Feb 26, 9:58 am, Ashish Jain <26may.1...@gmail.com>

$$Excel-Macros$$ Re: VBA to retrieve stock quotes from web

Its amazing as to what I learn from this group Keep sharing keep growing BEST regards Subu On Aug 5, 12:17 pm, Rakesh Sharma wrote: > Hi Peace, > > May be this would resolve your problem, > > Regards > Rakesh > > Yahoo! recommends that you upgr

$$Excel-Macros$$ Supplier invoice database / excel list

cumbersome, please ignore this request thanks in advance for your help / support -- Regards Subu mail_to_s...@yahoo.com New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does!

$$Excel-Macros$$ How to make XL Charzcters ...or general MS office Characters darker ?

size IS THERE a way to make the font / characters on screen darker ? Thanks in adv & Best regards subu --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Exce

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

& regards Subu On Jun 24, 2:02 pm, Rajesh Kunder wrote: > Hey use this code.. > > Sub SentenceCase() > For Each cell In Selection.Cells > s = cell.Value > Start = True > For i = 1 To Len(s) > ch = Mid(s, i, 1) >       Select Case ch >       Case &qu

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

On Jun 24, 5:11 pm, "MOKSH.." wrote: > it will help u > > =UPPER(LEFT(C3,1))&LOWER(RIGHT(C3,LEN(C3)-1)) > > with regards > Moksh > Bingo Krishna Worked like a charm...thanks a ton.. regards subu > 2009/6/24 Subu > > > > >

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

to UPPER case and rest of the letters to LOWER case. - You enclosed spread sheet does NOT seem to do that in case of examples like , name_fIVe ' name SIX , name sevEN etc... Please accept my thanks and keep up the good work. regards Subu On Jun 24, 4:48 pm, JAYAVELU SUN wrote: >

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

PPER(LEFT(B15,1))&LOWER(RIGHT(B15,LEN(B15)-1)) > Regards, > Swapnil. > *This worked Swapnil P : Great. Simple one, did the job* > On Wed, Jun 24, 2009 at 4:16 PM, Dilip Pandey wrote: > > Hi Subu, > > > Use the following function:- > > =PROPER(MID(A1,1,FIND(&quo

$$Excel-Macros$$ How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

Name_one Name_two Name_three Name_four Name_five Name six Name seven Thanks in advance Best regards Subu --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and

$$Excel-Macros$$ Re: Convert PDF to Excel (-PIN-)

As expected, the Rapidshare links are not working for free users... Are there any alternate downloads ? regards subu On Jun 1, 11:00 am, "Mudassar Ramzan" wrote: > Dear Gaurav, > Please download the following cracked version. Its > working fine fo

$$Excel-Macros$$ Sum and List based on Range of criteria

ts on what I wish to see. The original data sheet has the criteria range and sum ranges Hope I've made myself clear Thanks &Regards Subu New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before some

$$Excel-Macros$$ Re: Convert PDF to Excel (-PIN-)

Hi The link below works well. Thanks for the same. Is there an off line version ? i.e. instead of sending the file over the net (and being connected all the time) is there an off line version that can be used from one's own PC ? Thanks in advance Regards Subu > > From: e

$$Excel-Macros$$ Re: urgent need help for excel charts

Though I did NOT send the original request, I' amazed at the level of commitment and response from this group Please accept my appreciate and keep up the good work regards subu On Jun 1, 1:07 pm, Dilip Pandey wrote: > Hi Ruchi, > > Please find attached the workbook wit

$$Excel-Macros$$ Sum & list based on a range of criteria

n the same scenario, is it possible to list one line of sum per criteria ? Thanks in advance Best regards Subu --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: Protect and unprotect all sheets

Thanks again Andy... I shall visit the blog regards Subu On May 25, 11:06 am, Aindril De wrote: > Hi subu, there are hundreds of links available. > To start you can search in this group .. also you can check the following > link..http://funwithexcel.blogspot.com/search/label/Macro

$$Excel-Macros$$ Re: Protect and unprotect all sheets

Thanks for the reply and directing me the blog. Both were great Regards subu On May 25, 9:49 am, ddadmin2009 wrote: > Hi Subu, > To make your work easy assign the macro you have recorded to a shortcut key > or a button. Check the article below to get familiar with those >

$$Excel-Macros$$ Protect and unprotect all sheets

some list of useful macros (URL) or FAQ before you post questions to this group - again link/URL? I'd like to explore before I post the next question. TIA Regards Subu >== 2 of 2 == >Date: Sat, May 23 2009 7:12 am >From: Aindril De > >Dear Subu, > >First of all,

$$Excel-Macros$$ Protect and unprotect all sheets

te it on the XL sheet ? what commands should I use to make the macro run Other stats about me : - Win XP SP 3 user XL 2003 user I've recorded macros using "Record macro" facilities but never copied macros and used them I have _no_ VBA knowledge Thank

$$Excel-Macros$$ Where does XL store the clipboard ? or where does Windows store clipboard ?

automatically I face problems while copying (some error messages re. clipboard etc) I suspect that it has something to do with the backing up of my documents or standard files any help / pointers would be appreciated regards subu

$$Excel-Macros$$ Where does XL store the clipboard ? or where does Windows store clipboard ?

automatically I face problems while copying (some error messages re. clipboard etc) I suspect that it has something to do with the backing up of my documents or standard files any help / pointers would be appreciated regards subu

$$Excel-Macros$$ Re: Macros in Outlook

t; > > > > > Regards, > > > > > > > > > > > > Mudassar Ramzan > > > > > > > > - Original Message - > > > > > > From: shashank bhosle > > > > > > To: excel-macros@googlegroups.com > &

$$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

It would be ideal to use datedif formula like this C1 =DATEDIF(A1-1, B1, "Y") . For instance if your start date is 1-Jan-04 & end date is 31-Dec04 then datedif (without -1) will give you 0 as years where as you are expecting answer 1.. :) Regards Subu This will take care of the d