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"