Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-21 Thread Emamuddin Shah
Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote: > > Hi Paul, > > Hope you have received my email. > > Regards > Emam > > On Wednesday, February 1, 2017 at 12:5

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-05 Thread Emamuddin Shah
Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote: > > Dear Paul, > > i will share my both excel sheets, so that you can check where iam wrong > and correct it, since the document is confidenti

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-01-31 Thread Emamuddin Shah
of cells(1,3) > You're less likely to confuse the row/column. > > Of course, this doesn't apply when you're referring to the array index. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you ca

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-19 Thread Emamuddin Shah
on. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.”

$$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
ITS NOT UPDATED ALL 50 STRINGS ROW DETAILS. IT IS UPDATING ONLY FIRST MATCHED STRING ROW. On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote: > > Hello > > Iam trying to Loop so that it matched a string and then fills cells in > that row. > say

$$Excel-Macros$$ Re: Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
ster Tracker.xlsx").Close savechanges:=True Application.ScreenUpdating = True End Sub On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote: > > Hello > > Iam trying to Loop so that it matched a string and then fills cells in > that row. > say i have 50 strings

$$Excel-Macros$$ Once IF is met it is not looping

2016-10-18 Thread Emamuddin Shah
Hello Iam trying to Loop so that it matched a string and then fills cells in that row. say i have 50 strings to be matched and then update date on that row, data i have stored in ARRAY here is my part of code where I am struck ++= cm = 1 For i = 2 To lri If Cells(i, 7) =

Re: $$Excel-Macros$$ Fetching Data from excel based on current date

2016-08-26 Thread Emamuddin Shah
ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, August 4, 2016 5:45 AM, Emamuddin Shah <emt...@gmail.com > > wrote: > > &g

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
t;gb_70").Click > End With > End Sub > > On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah <emt...@gmail.com > > wrote: > >> Thanks Gaurav, but I don't want to navigate I want it to click that >> button. >> On Aug 25, 2016 6:40 PM, "Gaurav De

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
viceLogin?hl=en= > true=https://www.google.co.in/%3Fgfe_rd%3Dcr% > 26ei%3Dvuy-V726B9GL8Qf9qYW4CQ%26gws_rd%3Dssl" >End With > End Sub > > On Thu, Aug 25, 2016 at 6:48 AM, Emamuddin Shah <emt...@gmail.com> wrote: > >> Please suggest solutions... I just started vb

Re: $$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
Please suggest solutions... I just started vba crawling On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote: > Please disregard my email. > > On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote: > >> >&

$$Excel-Macros$$ Click Button on URL using VBA

2016-08-25 Thread Emamuddin Shah
Dear Friends, iam trying to click an button on url, please help my error CODE- Sub click1() Dim ie As InternetExplorerMedium Dim url As String Set ie = New InternetExplorerMedium '### BUILD THE FULL URL url = "www.google.com"

$$Excel-Macros$$ Fetching Data from excel based on current date

2016-08-04 Thread Emamuddin Shah
Hello All, iam an intermediate user of VBA i love to automate, iam struck in on of my code when iam using to fetch data from my excel sheet based on todays date and same thing copied after last rows. it is working but in last all copied cells goes empty.. here is my code please suggest.