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:

A

B

1

KT1

https://cscentral-eu.amazon.com/call-center-manager/historical-metrics?formId=_tFgdDjTQksLSAWpyfXOoY8u7is

2

KT2

https://cscentral-eu.amazon.com/call-center-manager/historical-metrics?formId=ReQ2-jRGxujxsHRMI12oo1-8mAw

3

FP

https://cscentral.amazon.com/call-center-manager/historical-metrics?formId=D45hBXzM5XFpCK5kfe2dd61ZLW4

4

USK

https://cscentral.amazon.com/call-center-manager/historical-metrics?formId=bgxYkzjpPuCCF0P02Iddy-z9KtI

<tbody>
</tbody>

Thanks,
AJ