View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Open browser from excel

Hi nivek,

Yes. When the CommandButton "cmdGo" is clicked, the following code will
open an IE window and navigate to the URL entered in the TextBox "txtURL":

Private Sub cmdGo_Click()
On Error GoTo ErrHandler

ThisWorkbook.FollowHyperlink txtURL.Text

ExitRoutine:
Exit Sub
ErrHandler:
MsgBox "Invalid URL. Please try again.", _
vbExclamation, "Invalid URL"
Resume ExitRoutine
End Sub


Enter this code in the code behind the Worksheet which contains your
controls. To do that, just right-click the sheet tab and select View Code,
then copy/paste this code into the code window.


--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


nivek wrote:
Is it possible to open a new instance of internet explorer with a
command button and pass it an address from an text box in excel? If
so, can someone please give an example of syntax?


TIA,
nivek