Microsoft Teams
A Microsoft customizable chat-based workspace.
10,462 questions
Hello,
I removed the trailing "?web=!" and seems to have solved the issue.
Regards,
Douglas
VBA Open Excel Workbooks in Teams as read/write
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 66%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Douglas Prince
1
Reputation point
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
Microsoft Teams
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,063 questions
1 answer
Sort by: Most helpful
-
Douglas Prince 1 Reputation point
2022-02-16T13:34:34.313+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 3%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Christine Rieger 1 Reputation point2022-12-14T04:08:41.853+00:00 Hi Douglas
How did you figure out the path?
OneDrive is driving me around the bend so I'm trying if I can access the files in my VBA directly from Teams. When I open a file in the browser, the link looks like this. The file seems to be identified by a code, rather than its name.
Does the file open for you in the browser, or the App?
Thanks,
Christine
Sign in to comment -