Hi all,

Hope all are well.

I am using below macro to open excel file from an online sharepoint link and its working successfully.

Sub OpenAllExcelFilesInFolder()
    Dim folderPath As String
    Dim fileName As String

   folderPath = "https://myteams.gsk.com/sites/Serialisation Governance/Business Process Support/EU Data Errors in ATTP EMVS/Alerts/Test/"
   Workbooks.Open fileName:="https://myteams.gsk.com/sites/Serialisation Governance/Business Process Support/EU Data Errors in ATTP EMVS/Alerts/Alerts logs 2024/EMVS Alerts Log - Benelux 2024.xlsm"
End Sub
However, there are 9 more files to be opened and therefore i modified the line as below to open 2 files at once.

Workbooks.Open fileName:="https://myteams.gsk.com/sites/Serialisation Governance/Business Process Support/EU Data Errors in ATTP EMVS/Alerts/Alerts logs 2024/EMVS Alerts Log - Benelux 2024.xlsm","https://myteams.gsk.com/sites/Serialisation Governance/Business Process Support/EU Data Errors in ATTP EMVS/Alerts/Alerts logs 2024/EMVS Alerts Log - Scanda 2024.xlsm"
But now the code doesn't work. Can someone please help how to add code for multiple files? Thanks in advance.