Hi all, How can I open Internet URL from excel macro? In other words
when I click button then the URL address indicated in macro should
open up in Internet window

Try

ActiveWorkbook.FollowHyperlink Address:="http://www.google.com",
NewWindow:=True

Mike

"K" wrote:

Hi all, How can I open Internet URL from excel macro? In other words
when I click button then the URL address indicated in macro should
open up in Internet window

On Sep 5, 11:15*am, Mike H wrote:
Try

ActiveWorkbook.FollowHyperlink Address:="http://www.google.com",
NewWindow:=True

Mike



"K" wrote:
Hi all, *How can I open Internet URL from excel macro? *In other words
when I click button then the URL address indicated in macro should
open up in Internet window- Hide quoted text -

- Show quoted text -

Thanks Mike

I am working on something similar. However I have a list of numbers I need
to look up then return the values of what I look up on the website(which has
a user id and password). I have written macros to pull data from mainframes
where I know the position of the data. How do I pull it from a web page.

"Mike H" wrote:

Try

ActiveWorkbook.FollowHyperlink Address:="http://www.google.com",
NewWindow:=True

Mike

"K" wrote:

Hi all, How can I open Internet URL from excel macro? In other words
when I click button then the URL address indicated in macro should
open up in Internet window