AlbertJoseph
New Member
- Joined
- Sep 21, 2018
- Messages
- 3
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:
<tbody>
</tbody>
Thanks,
AJ
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