Macro to Retrieve Values From A Password Protected Workbook on SharePoint Without Opening It

Hello,

I'm relatively new to VBA so please bear with me.

I'm in need of a macro to retrieve data from a password protected workbook that's on SharePoint. The masterbook that I'm working on will retrieve the values from a sheet that's inside the protected workbook and set values of a sheet inside the masterbook accordingly. It needs to run without any user prompt and without opening the workbook.

I'm familiar with basics of VBA. Working with objects and such.

I can do this by opening the workbook but It's not what I need.

This is what I could find on Google.

Sub Dummy()
Dim rgTarget As Range
Set rgTarget = ActiveSheet.Range("G2:H10") 'where to put the copied data.
rgTarget.FormulaArray = "='D:\[Product_Details.xlsx]Sheet1'!$B$4:$E$10"
rgTarget.Formula = rgTarget.Value
End Sub

I'm not sure if it'd would work with a SP address and I'm not sure where to put the password.

I'd greatly appreciate your assistance.

Thank you.