Re: $$Excel-Macros$$ Sumif multiple column

PFA On Friday, August 26, 2016 10:52 AM, Deepak Rawat wrote: Hi, Need sumif function to sum multiple columns sample excel attached. Regards,Deepak -- 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

$$Excel-Macros$$ Sumif multiple column

Hi, Need sumif function to sum multiple columns sample excel attached. Regards, Deepak -- 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

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

I GOT THIS ERROR, run-time error '-2147467259(80004005)': Method 'document' of object "IWebBrowser2' failed On Thursday, August 25, 2016 at 8:01:51 PM UTC+5:30, Gaurav Devrani wrote: > > Hi, > > check this out. > > Sub Scraping() >Dim appIE As

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

Hi, check this out. Sub Scraping() Dim appIE As Object Set appIE = CreateObject("internetexplorer.application") With appIE .Visible = True .navigate " https://www.google.co.in/?gfe_rd=cr=vuy-V726B9GL8Qf9qYW4CQ_rd=ssl;

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

Thanks Gaurav, but I don't want to navigate I want it to click that button. On Aug 25, 2016 6:40 PM, "Gaurav Devrani" wrote: > Hi , > > Check this code. I have just navigated the sign in link. > > Sub Scraping() >Dim appIE As Object >Set appIE =

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

Hi , Check this code. I have just navigated the sign in link. Sub Scraping() Dim appIE As Object Set appIE = CreateObject("internetexplorer.application") With appIE .Visible = True .navigate " https://www.google.co.in/?gfe_rd=cr=vuy-V726B9GL8Qf9qYW4CQ_rd=ssl;

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

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 click an

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

Please disregard my email. On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah wrote: > > > 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

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

Hi, Please check the below code. Sub Click() Dim objIE As Object Dim strURLAs String Set objIE = CreateObject("InternetExplorer.application") strURL = "www.google.com" With objIE .Visible

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

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"

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Please add my number in what'sup group 9910243729 Thanks Manoj On Thu, Aug 11, 2016 at 11:24 AM, Manoj Garg wrote: > Please add 9927199217 > > On Aug 11, 2016 8:51 AM, "Kishore P V K" wrote: > >> Please add 9348264783 >> >> On Wed, Aug 10, 2016 at

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

PFA On Tuesday, August 23, 2016 2:35 PM, Pravin Gunjal wrote: Dear Gaurav Thanks for solution. You have created a sheet viz. Tab-Names and then used two macros based on requirement. But my worry is that in every month number of sheets are getting changed and I