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
C instead 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 c

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

2016-10-19 Thread Emamuddin Shah
nd iteration. > > *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

$$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 i hav

$$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) = c

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

2016-08-25 Thread Emamuddin Shah
ll 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.” - John Wesley* > - > > > On Thursday, August 4, 2016 5:45 AM, Emamuddin S

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

2016-08-25 Thread Emamuddin Shah
t;appIE.document.getElementByid("gb_70").Click >End With > End Sub > > On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah > wrote: > >> Thanks Gaurav, but I don't want to navigate I want it to click that >> button. >> On Aug 25, 2016 6:40

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

2016-08-25 Thread Emamuddin Shah
hl=en&passive= > true&continue=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 wrote: > >> Please suggest solutions... I just started vba crawling

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" wrote: > Please disregard my email. > > On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah wrote: > >> >> >> Dear Friends, >> >> iam trying to cli

$$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" Wi

$$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. Sub