$$Excel-Macros$$ Re: Change FROM email address

2009-11-17 Thread RolfJ
Did you already try to simply assign your team's group email address to the .From property of the mail item? On Nov 16, 9:01 am, Hanum wrote: > I have some VBA code that sends an email automatically after attaching > an Excel file. > The email gets sent using my corporate email account. Is there

Re: $$Excel-Macros$$ Problem with Calling a Sub in a Module from a Form

2009-11-17 Thread laudes
Thank you too, for your answer PMann... On 16 Nov., 19:10, PMann wrote: > You could just use Global variables. > On the On_Click event set the globals = to the value in the textboxes on > your form. > > On Mon, Nov 16, 2009 at 6:50 AM, laudes wrote: > > > Thank you a lot for your help. It worked

$$Excel-Macros$$ pls suggest me

2009-11-17 Thread Devasiah P
Hi, I am struggling to manage stock of forms and application in my organisation. I have 23 types of application/forms which will move on daily basis. and i will distribute these forms only to 11 persons. Here I have to maintain stock report for all the forms on monthly basis. and I have

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread Deepak Rai
Hi, Thanks if my solution helped u, for this problem I need detailed explanation of your problem. Regards, Deepak Rai On Tue, Nov 17, 2009 at 8:56 PM, vinod rao wrote: > Thanks Andy. Plz help me on other file about deleting columns > > > On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: >

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread Aindril De
Hi VR Could you explain the requirement a little more. On Tue, Nov 17, 2009 at 10:26 PM, vinod rao wrote: > Thanks Andy. Plz help me on other file about deleting columns > > > On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: > >> Hi VR, >> >> Please use the following code: >> >> Sub TispPAT()

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread vinod rao
Thanks Andy. Plz help me on other file about deleting columns On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: > Hi VR, > > Please use the following code: > > Sub TispPAT() > 'Macro created by Aindril De(Andy) > 'Shortcut Ctrl + Shift + p > Dim CurCell As Object > Dim i As Integer >

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread vinod rao
HI Deepak, Great!!! It worked fine. I have another requirement like deleting column based on given headder. Is that possible? Plz find attached. Hope it should not be difficult for you. Thanks in advance for your help. Regards, VR On Tue, Nov 17, 2009 at 8:08 PM, Deepak Rai wrote: > Hi, > > As

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread Aindril De
Hi VR, Please use the following code: Sub TispPAT() 'Macro created by Aindril De(Andy) 'Shortcut Ctrl + Shift + p Dim CurCell As Object Dim i As Integer i = 4 For Each CurCell In Range("B4:B11") Range("B" & i).Activate If ActiveCell.Value = "Tisp" And Active

Re: $$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread Deepak Rai
Hi, As per my understanding I have attached a solution of it. Please find the attached file. Regards, Deepak Rai On Tue, Nov 17, 2009 at 6:45 PM, vinod rao wrote: > Hello Team, > > I need a macro to change Column B from Tisp to PAT if the Column D is Core > > Regards, > VR > > -- > >

$$Excel-Macros$$ Re: Urgent help on simple macro

2009-11-17 Thread ECMG
Hi Vinod Try the Macro below. Sub update() Dim x As Integer x = 3 Do While Sheet1.Cells(x, 2).Value <> "" If Sheet1.Cells(x, 4).Value = "Core" Then Sheet1.Cells(x, 2).Value = "PAT" End If x = x + 1 Loop End Sub -- -

$$Excel-Macros$$ Urgent help on simple macro

2009-11-17 Thread vinod rao
Hello Team, I need a macro to change Column B from Tisp to PAT if the Column D is Core Regards, VR -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at h