I have a website that I would like to hyperlink guests to specific products under my shopping page from a "shop now" button in an excel spreadsheet. The way the website works (which I do not have control over) is that the person has to open my home page before they can get to the shop now portion and product selection. I tried to create a hyperlink to the specific products, but the website will not allow for this. Therefore I am creating a macro. I do not know anything about macros but have managed to write the following from searching the internet for codes:
Sub ShopNow()
ActiveWorkbook.FollowHyperlink Address:="http://www.myphproducts.com/jmcvarnock"
ActiveWorkbook.FollowHyperlink Address:="http://www.myphproducts.com/shop/productdetail.aspx?prod=6688"
End Sub
It opens nicely to the product page, but what I would like is for the second url to open in the same tab so a person does not end up with two tabs open on their browser. Can someone help me with the language for this?
Thanks,
Julie