MS Teams - Would the macro work on a file that is stored online in MS Teams

What I would like to know is that would the macro work on a file that is stored online in SharePoint also there are different folder paths defined in my macro so how to amend the same to fetch the file  destinations and location in Teams.

I have a MS excel that grabs data from MS word with VBA. But since my MS word are stored in MS teams files. How do i go about with the set up of the VBA?