Right way to use Macro enabled Excel files on Microsoft Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-292121%22%20slang%3D%22en-US%22%3ERight%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMy%20company%20has%20a%20bunch%20of%20Macro%20enabled%20Excel%20files.%20We%20have%20been%20in%20a%20steady%20progress%20of%20migrating%20our%20data%20to%20Microsoft%20Teams.%20I%20have%20been%20informed%20that%20the%20Macros%20don't%20work%20on%20Microsoft%20Teams.%20What%20would%20be%20the%20right%20way%20to%20execute%20Macros%20on%20Microsoft%20Teams%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-292121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292551%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292551%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247043%22%20target%3D%22_blank%22%3E%40Jebin%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20the%20scenario%20right%2C%20I%20do%20not%20believe%20there%20is%20a%20way%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20understanding%20is%20that%20Excel%20will%20hardcode%20those%20locations%20and%20SharePoint%20Online%20doesn't%20have%20the%20same%20structure%20as%20say%20a%20file%20drive%20would.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20be%20wrong%20but%20I%20doubt%20you%20can%20do%20this!%20Anyone%20else%20know%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292549%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292549%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhat%20I%20would%20like%20to%20know%20is%20that%20would%20the%20macro%20work%20on%20a%20file%20that%20is%20stored%20online%20in%20SharePoint%20also%20there%20are%20different%20folder%20paths%20defined%20in%20my%20macro%20so%20how%20to%20amend%20the%20same%20to%20fetch%20the%20file%26nbsp%3B%20destinations%20and%20location%20in%20Teams%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292351%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292351%22%20slang%3D%22en-US%22%3E%3CP%3EMacros%20don't%20run%20in%20the%20web-based%20Office%20versions%2C%20thus%20in%20Teams%20as%20well.%20You%20should%20still%20be%20able%20to%20open%20the%20file%2C%20but%20if%20you%20want%20the%20macro%20to%20execute%2C%20open%20it%20with%20the%20desktop%20Excel%20app.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1390227%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20think%20you%20are%20correct.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EExcel%20macros%20write%20to%20a%20network%20fileshare%2C%20while%20Teams%20has%20a%20different%20protocol%2C%20you%20would%20have%20to%20make%20API%20calls%20(HTTP%20REST)%2C%20authenticate%20most%20likely%2C%20etc.%26nbsp%3B%20When%20people%20migrate%20from%20Excel%20Macros%20to%20microsoft%20online%2FO365%2FTeams%2Fetc.%20they%20have%20to%20re-write%20their%20VBA%20macros%20in%20Javascript.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20this%20on%20another%20link%2C%20it%20may%20be%20useful%20for%20people%20to%20try%20the%20'self-service'%20type%20'Flow'%20app.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.reddit.com%2Fr%2Fexcel%2Fcomments%2Fbalh98%2Fexcel_vba_macros_and_microsoft_teams%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.reddit.com%2Fr%2Fexcel%2Fcomments%2Fbalh98%2Fexcel_vba_macros_and_microsoft_teams%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fmicrosoft-flow-in-microsoft-teams%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fmicrosoft-flow-in-microsoft-teams%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1410764%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20way%20to%20use%20Macro%20enabled%20Excel%20files%20on%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247043%22%20target%3D%22_blank%22%3E%40Jebin%3C%2FA%3EJust%20save%20the%20files%20in%20trusted%20location.%20File-%20Option-Trust%20center%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

My company has a bunch of Macro enabled Excel files. We have been in a steady progress of migrating our data to Microsoft Teams. I have been informed that the Macros don't work on Microsoft Teams. What would be the right way to execute Macros on Microsoft Teams

5 Replies
Highlighted

Macros don't run in the web-based Office versions, thus in Teams as well. You should still be able to open the file, but if you want the macro to execute, open it with the desktop Excel app.

Highlighted

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 

Highlighted

Hi @Jebin

 

If I understand the scenario right, I do not believe there is a way to do this.

 

My understanding is that Excel will hardcode those locations and SharePoint Online doesn't have the same structure as say a file drive would.

 

I could be wrong but I doubt you can do this! Anyone else know?

 

Cheers

Damien

Highlighted

@Damien Rosario 

 

Yes I think you are correct.


Excel macros write to a network fileshare, while Teams has a different protocol, you would have to make API calls (HTTP REST), authenticate most likely, etc.  When people migrate from Excel Macros to microsoft online/O365/Teams/etc. they have to re-write their VBA macros in Javascript.

 

Found this on another link, it may be useful for people to try the 'self-service' type 'Flow' app.

https://www.reddit.com/r/excel/comments/balh98/excel_vba_macros_and_microsoft_teams/

https://flow.microsoft.com/en-us/blog/microsoft-flow-in-microsoft-teams/

@JebinJust save the files in trusted location. File- Option-Trust center