$$Excel-Macros$$ mail merge with Cc options

Dear Experts, I know basic of mail merge and using from several years. Now I need to add cc and bcc in mail merge and is it possible to pick the subject line from excel itself. I want to use the separate subject for each email. Request you to provide me any macros and steps to be followed. Rega

Re: $$Excel-Macros$$ Border Issue in VBA

Hello, Thanks its working fine :) On Wed, Feb 12, 2014 at 7:25 PM, priti verma wrote: > you can use only these line change range according to yours- > > Range("a1").CurrentRegion.borders.Weight = 2 > Range("a1").CurrentRegion.BorderAround , xlMedium > > > On Wed, Feb 12, 2014 at 5:43 AM, Chandr

Re: $$Excel-Macros$$ Codes for SubPart

Hi Arvind, You can achive this using formula also. PFA excel. Regards, Swapnil. On Thu, Feb 13, 2014 at 1:17 PM, pankaj sangotra wrote: > Please try this hope this will help.. > > Sub output() > Dim i As Integer, k As Integer, j As Integer > k = 1 > For i = 1 To 5 > For j = 97 To 100 >

$$Excel-Macros$$ hi

-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ IF statement to call a number of CmdSave ?

Hi Tricia, could share a sample file tks. Basole 2014-02-13 17:33 GMT-02:00 Tricia Guitard : > I am very new to VBA but I have learned so much thanks these forums so > thank you! I could really use some help right now. > > I have created a questionnaire in Excel. For each question, the user >

$$Excel-Macros$$ IF statement to call a number of CmdSave ?

I am very new to VBA but I have learned so much thanks these forums so thank you! I could really use some help right now. I have created a questionnaire in Excel. For each question, the user answers yes, no, or NA. If the answer is no, they have to select the error from a list which generates a

Re: $$Excel-Macros$$ Months between two dates.

Thanks Ashish but Please observe my initial draft. Datedif I know very well on the usage and it fails. Regards On Thu, Feb 13, 2014 at 5:58 PM, Ashish Kumar wrote: > Hi Ahmed, > > PFA..!!! > > > Thanks > Ashish > > > > On 13 February 2014 20:15, Ahmed Honest wrote: > >> Dear All, >> >> Ple

Re: $$Excel-Macros$$ Months between two dates.

Hi Ahmed, PFA..!!! Thanks Ashish On 13 February 2014 20:15, Ahmed Honest wrote: > Dear All, > > Please see below and kindly help. > > Requirement : How to get no. of years, months and Dates between 2 dates. > > Example : > Start date : 1-Oct-2012 suppose in cell A1, > End Date : 30-Jun-

$$Excel-Macros$$ Months between two dates.

Dear All, Please see below and kindly help. Requirement : How to get no. of years, months and Dates between 2 dates. Example : Start date : 1-Oct-2012 suppose in cell A1, End Date : 30-Jun-2013 suppose in cell B1 Then used formula is : 1. Datedif(a1,b1,"Y") for years = Output is zero 2. Datedif

$$Excel-Macros$$ Re: recordset vs collections

> > Hi > >From what i understand I want to use pessemistic record level locking and this is the default behaviour of the recordset object when used so do i actually need to make any amendments to my normal use of code i.e. The current record being used by ADOrecordset is pessemistically locked

Fwd: $$Excel-Macros$$ COUNT OF RECOVERY DAYS

-- Forwarded message -- From: SUDHIR VERMA Date: 12 February 2014 21:34 Subject: $$Excel-Macros$$ COUNT OF RECOVERY DAYS To: excel-macros Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- Are you =EXP(E:RT) o

Re: $$Excel-Macros$$ recordset vs collections

or use this one. http://msdn.microsoft.com/en-us/library/office/aa141422%28v=office.10%29.aspx On Thu, Feb 13, 2014 at 6:00 PM, Anoop K Sharma wrote: > There is a recordset property which lock the data while reading it through > query. > > > On Thu, Feb 13, 2014 at 5:41 PM, Keith Willis wrote:

$$Excel-Macros$$ Re: recordset vs collections

> > Hi Enrique > Thanks for getting back to me, are you able to post an example, i'm a bit new to this and the help system is being decidedly unhelpful :) Thanks Keith -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Faceb

Re: $$Excel-Macros$$ recordset vs collections

There is a recordset property which lock the data while reading it through query. On Thu, Feb 13, 2014 at 5:41 PM, Keith Willis wrote: > Hi all > > I'm developing a project thats going to be a excel front end to a SQL db. > One part of the required functionality is that you performa a search on

$$Excel-Macros$$ recordset vs collections

Hi all I'm developing a project thats going to be a excel front end to a SQL db. One part of the required functionality is that you performa a search on the database and return possibly mutliple records for review or amendment on a userform. Normally i read data from a recordset into a collecti