Macro of web page link

[Sandeep Singh]

Hi All,

I have broke the link into two from between. The broken link is in 2 different cells. And there are 2 cells whose data should also be included in this link, then only the link is complete. I have used the below code to run a link

Sub openlinkweb()
Dim wLink As String wLink = Range("I10") & Range("D8").Value & Range("D11").Value & Range("I13").Value ActiveWorkbook.FollowHyperlink Address:=wLink, NewWindow:=True End Sub <tbody> </tbody>
Its error free. I have assigned this macro to a button. Once i click the button the link is getting opened and its fine and second time when i click its getting open again, now I have 2 web pages open. My question is when i click button second time the web page should not be open, as its already opened open, it should only get refreshed.

<tbody>
</tbody>

 

[SQUIDD]

Hi

Have you tried doing it using web query instead?

Dave

 

[Sandeep Singh]

No, i don't know about this.