how to open a url in a new window from VBA on Excel

  • Thread starter Thread starter SMV
  • Start date Start date
S

SMV

Hi,

How do we open a url in a new window from VBA on Excel?
I am checking some values in the cell and depends upon the
value, it should direct to particular url.

please help.

Thanks in advance
 
The basic statements to open an URL using VAB is:

If Workbooks.Count = 0 Then Workbooks.add
ActiveWorkbook.FollowHyperlink address:="http://www.microsoft.com", NewWindow:=True

Note the first line to add a new workbook if no workbook is currently available. This is not mandatory. But in case there is no workbook available, the FollowHyperlink link will give an error. Use that line if you're working on an add-in. Ingnore that if not.
 
Back
Top