I have written a code for web data downloading using selenium VBA, it works good in Firefox, but many time Firefox is crashing. I tried to launch chrome/IE from vba but it's not properly happening. Below is my code....please help.
Public Sub Untitled_2()
Dim selenium As New SeleniumWrapper.WebDriver
Dim By As New By, Assert As New Assert, Verify As New Verify, Waiter As New Waiter
driver.start "firefox", "https://indexes.nasdaqomx.com/Account/LogOn"
'below 2 line don't work
driver.start "ie", "https://indexes.nasdaqomx.com/Account/LogOn"
driver.start "chrome", "https://indexes.nasdaqomx.com/Account/LogOn"
selenium.setImplicitWait 10000
selenium.Type "css=fieldset > div.editor-field > #UserName", "xxxxxxx"
selenium.Type "css=fieldset > div.editor-field > #Password", "xxxxxxx"
selenium.clickAndWait "css=fieldset > p > input.button.submit"
selenium.Click "id=menu-5"
selenium.Click "id=menu-1"
selenium.clickAndWait "link=U.S."
selenium.clickAndWait "id=NDX"
selenium.clickAndWait "link=Weighting"
selenium.Click "id=tradeDate"
selenium.Click "link=20"
selenium.Select "id=timeOfDay", "label=End of Day"
selenium.Click "id=update"
selenium.clickAndWait "id=exportLink"
selenium.Stop
End Sub
Error screenshot is as below:
How to launch chrome or IE ?
My chrome driver path is C:\Program Files (x86)\SeleniumWrapper\chromedriver.exe"
and ie driver path is C:\Program Files (x86)\SeleniumWrapper\IEDriverServer.exe"
