Forum Discussion

Jebin's avatar
Jebin
Copper Contributor
Nov 28, 2018

Right way to use Macro enabled Excel files on Microsoft Teams

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

Excel Online
Macros and VBA

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 28, 2018

    Hi Jebin,

     

    Yes, macros don't work (actually that's Excel Online) but in Teams you have the possibility from the menu to open the file in desktop application, that's one more extra click. It looks like

     

    • Jebin's avatar
      Jebin
      Copper Contributor
      Nov 28, 2018

      I understand that I can open the files in the Desktop Application. What I wanted to know was 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 

Resources