Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open a url in a new window from VBA on Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open a url in a new window from VBA on Excel
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can only open one window with excel | Excel Discussion (Misc queries) | |||
I need to open all Hyperlinks in excel in same window | Excel Discussion (Misc queries) | |||
Open Excel Hyperlinks in a new window | Excel Discussion (Misc queries) | |||
excel open in new window | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |