View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hotbero@hotmail.com is offline
external usenet poster
 
Posts: 8
Default Access a Web Site from VBA,

Hi!

I need a macro to access a web site from vba.

I do know How to use:
ActiveSheet.Hyperlinks.Add _
Anchor:=Selection, Address:= _
"http://www.allexperts.com", _
TextToDisplay:="Text to Dispaly"

BUT THIS IS NOT THE CASE!!


So I need some thing like:

Sub Eg()
Application.Open "www.google.com"
End Sub


This way when I presh Eg, I go directly to the desired Web Site, in
this example to www.gogle.com



PS: Please avoid sending me Hyperlinks examples using a range, a cell
and/or a selection.

This has to be done from VBA, and I have to go to the desired Web
Site from my macro!!!

Many Thanks!!!!!!!