search

sarmisen / selenium-vba

Automatically exported from code.google.com/p/selenium-vba
0 stars 0 forks source link

Getting Automation Error while executing the VBA code #1

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Public Sub TC001()
  Dim selenium As New SeleniumWrapper.WebDriver
  selenium.Start "firefox", "http://www.google.co.in/"
  selenium.Open "http://www.google.co.in"
  selenium.Type "name=q", "Eiffel tower"
  selenium.Click "name=btnG"
  selenium.stop
End Sub

Run the above code in Excel VBA

Actual Result:-

Getting Automation Error in line:-
selenium.Start "firefox", "http://www.google.co.in/"

Info: I am using:-
OS: XP
Office: Microsoft Excel 2000

Original issue reported on code.google.com by nishant....@gmail.com on 13 Apr 2012 at 7:31

GoogleCodeExporter commented 9 years ago 
Possible causes of your error:
1-Mozilla Firefox 8 or sup is not installed
 If not, install it.
2-Microsoft .Net Framework 3.5 is not installed
 If not, install it.
3-Your Office 2000 has issues with .NET 3.5 libraries (My minimum requirement 
is Office 2003)
 This Automation Error is because Office 2000 and 2003 by default are tied to .NET Framework 1.1.
 Paste the http://selenium-vba.googlecode.com/svn/trunk/wrapper/EXCEL.EXE.CONFIG in the same folder as EXCEL.EXE
 Restart Excel
 More information about this Microsoft issue :
 http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/02/15/office-clr2-lockback-bypass.aspx

Original comment by florentbr on 18 Apr 2012 at 9:26

GoogleCodeExporter commented 9 years ago

Original comment by florentbr on 8 Sep 2014 at 5:33