VBA Open Excel Workbooks in Teams as read/write

Question

Hello,

What is the VBA code for opening an Excel workbook that is saved in Teams as read/write?

I have found how to open a Workbook but it is READ only. If i make any changes i ned to save a copy.

Dim sPath as string

sPath = **** 'my location

Workbooks.Open sPath & "/Structures%20-%20Staff%20engagement%20tracker.xlsx?web=1)", , False

The above works for opening as read only. I have tried changing the optional parameters for ReadOnly to False, with no success.

Is there another way?

Regards,
Douglas

Answer 1

Hello,

I removed the trailing "?web=!" and seems to have solved the issue.

Regards,
Douglas