VBA - Open New I/E or New Tab

[Catsonheat]

Hi all,

I have a simple macro which is to follow a hyper link:

Private Sub Btn_Click()
ThisWorkbook.FollowHyperlink "http://mylink"
End Sub

This works however sometimes i get an error message: Run-time error '-2147023706 (800704a6) Method 'FollowHyperlink' of object '_workbook' failed.

This only appears some times and I am not 100% sure but when trying to recreate it I believe it occurs when switching between an open I/E or Chrome instance. So I need a code that will open a new instance of I/E if one is not already open, if one is already open then it will just open the link in a new tab.

Can anyone assist?

Thanks in advance

[GuruWannaB]

Please Login or Register  to view this content.