Open Multiple links to Mozilla Firefox Using VBA

[AlbertJoseph]

Hi Everyone!

I want to open multiple links in a worksheet to firefox via VBA and i want to edit the date on the web page that was opened. I am a complete VBA beginner, anyone please help. Loop the function and open 1 by 1 the links stored in excel. Below is the code.


Function FnLaunchFF()


Dim objShell

Set objShell = CreateObject("WScript.Shell")

objShell.Run ("""C:\Users\regalber\AppData\Local\Mozilla Firefox\Firefox.exe""" & .Range("B1").Value)

Set objShell = Nothing



End Function


List of links:

[TABLE="width: 993"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]KT1[/TD]
[TD="colspan: 12"]https://cscentral-eu.amazon.com/call-center-manager/historical-metrics?formId=_tFgdDjTQksLSAWpyfXOoY8u7is[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]KT2[/TD]
[TD="colspan: 12"]https://cscentral-eu.amazon.com/call-center-manager/historical-metrics?formId=ReQ2-jRGxujxsHRMI12oo1-8mAw[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]FP[/TD]
[TD="colspan: 11"]https://cscentral.amazon.com/call-center-manager/historical-metrics?formId=D45hBXzM5XFpCK5kfe2dd61ZLW4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]USK[/TD]
[TD="colspan: 10"]https://cscentral.amazon.com/call-center-manager/historical-metrics?formId=bgxYkzjpPuCCF0P02Iddy-z9KtI[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks,
AJ