Mutsop
asked on
excel followhyperlink with cells
Hi,
I'm trying to setup a button on my excel sheet which will open IE or any other browser using some parameters as cell values:
As you can see in the code below I would like to have
ms=BE&iso=BE&vat=040449484 9
BE as cell A5 for example (both)
Vat as cell A6
Any ideas,
Regards
I'm trying to setup a button on my excel sheet which will open IE or any other browser using some parameters as cell values:
As you can see in the code below I would like to have
ms=BE&iso=BE&vat=040449484
BE as cell A5 for example (both)
Vat as cell A6
Any ideas,
Regards
Sub Knop3_BijKlikken()
ActiveWorkbook.FollowHyperlink Address:="http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms=BE&iso=BE&vat=0404494849", _
NewWindow:=True
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
For those interested: