To open an Excel file from sharepoint folder using VBA

HI,


I have my Excel file stored in the SharePoint and would like to have an vba to Access that Excel file.

The Excel file, i Need is stored in ; SharePoint>> Document >> Test >> Data >>July >>Trial.xlsx

This is how my SharePoint Looks like, this is not the exact link, just an sample.
https://forum/content/008200/default.aspx?RootFolder=%2Fcontent%2F00008200%20Documents%2DTest%2F0001%20%29&FolderCTID=0x01200083BC38D90EC5674491B520CC48282737&View={00112127-0FE6-44A4-A5FB-86BC6C4E835B}&InitialTabId=Ribbon%2EDocument&VisibilityContext=WSSTabPersistence


Could someone help me how i can Code, to open the Excel file, stored in SharePoint.

I tried a code, below, but it dint work with me. I am confused where i should mention my Folder Name

Please Login or Register  to view this content.

Regards
Mikz

Hi,

Thank you for your Response, I already tried it and it dint work .

To add on, I already know my Excel file Location. so I dont Need to open an file open Dialog box.

Could you suggest me a code, how i could open an Excel file from SharePoint assuming my Excel file in SharePoint is in Location

Documents \\ july \\ raw \\ raw.xlsx


Regards
Mikz

so, it should be just
.InitialFileName = "\\forum\Content\008200\default.aspx" & "\\july\\raw\\raw.xlsx" ?