Hi
I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”.
But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help!
I think it is the same if stored in SharePoint(?) due to SharePoint is “back-end” to MS Teams.
I want to use a “Upload” button in the master file.
The User change data and click ”Upload” and only get a message “Upload complete”.
Everything else will be too complicated to my users …
I can do this on a network drive like this :
I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”.
But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help!
I think it is the same if stored in SharePoint(?) due to SharePoint is “back-end” to MS Teams.
I want to use a “Upload” button in the master file.
The User change data and click ”Upload” and only get a message “Upload complete”.
Everything else will be too complicated to my users …

I can do this on a network drive like this :
Code:
Set wb = Workbooks.Open(lnk + fname, ReadOnly:=False, editable:=True, Local:=True)