access a website with username/password

**redrav26** · 11-16-2009, 12:29 PM

Hi,

I'm a new user to excel VBA. I'm trying to create a simple macro which would allow me to open an internet explorer broser, to a website, for example, hotmail, and automatically input my username and password.

Can anybody help??

Thanks

**mrice** · 11-16-2009, 05:35 PM

I do this every time I access this Forum. I have Ruby installed on my PC and also WATIR which is a Ruby based web testing library. Both are open source and free.

Running the following Ruby Program logs me onto this forum and looks for unanswered posts.

require 'watir'
require 'watir/WindowHelper'
include Watir
require 'test/unit'
class TC_recorded < Test:: Unit:: TestCase
 def test_1
  $IE0 = IE.new

  $IE0.goto("http://www.excelforum.com/search.php")
  $IE0.wait
    $IE0.form( :name, "vbform").select_list( :name, "replyless").select('At Most')
$IE0.wait
    $IE0.form( :name, "vbform").select_list( :name, "searchdate").select('A Week Ago')
  $IE0.wait
    $IE0.form( :name, "vbform").button( :name, "dosearch").click
  
 end
end

Similarly for threads that I am involved in

require 'watir'
require 'watir/WindowHelper'
include Watir
require 'test/unit'
class TC_recorded < Test:: Unit:: TestCase
 def test_1
  $IE0 = IE.new
  $IE0.goto("http://www.excelforum.com/search.php")
  $IE0.wait
  $IE0.form( :name, "vbform").text_field( :name,"searchuser").set("mrice")
    $IE0.wait
    $IE0.form( :name, "vbform").select_list( :name, "replyless").select('At Least')
  $IE0.wait
    $IE0.form( :name, "vbform").button( :name, "dosearch").click
  
 end
end

If you macro shells the ruby executable with a file like the above as an argument, you will get the effect that you want.