Migration Macros Excel to SharePoint Teams Site

Question

Hi, 

Is Macros Excel will be working after migrate to SharePoint Teams Site? If not working, what is the consideration should we take if we want move to O365.

Currently, our we have a lot of Macros files in their File Share (Right now we're using Office 2010). We're facing problem with Macros file if using Office 2013 or Office 2016. We’re planning to migrate the file to SharePoint Team site without breaking excel file.

Answer 1

Hi NorafifyJalil,

Thank you for posting your query in our community.

You mentioned that you want to migrate Excel macro-enabled workbook (.xlsm) to SharePoint Online, since Office for the web doesn't support macros, so you can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web. However, you can open and edit a workbook that contains macros but macros do not run in a browser window. Any existing macros will remain in the workbook, and you can open the workbook in the Excel desktop app to view and edit the macros.

Since you also mentioned "Macros file if using Office 2013 or Office 2016", may I confirm that whether you want to use SharePoint Online which is from Microsoft Office 365 product and Excel 2013 or 2016 client? If yes, I want to explain that they are two different products. So when you click "Open in Desktop App" to open the macro-enabled workbooks from client, you need to sign in account which login to SharePoint Online to open the file.

If you still have any concern about it or my understanding is wrong, please feel free to post back.

Best regards,

Jazlyn

Answer 2

Hi Jazlyn, 

Thank you for the explanation, 

Yes, we will use Excel 2013 or Excel 2016 because we're using M Business Basic License only as for now.

Meaning this file macros still working fine if they're migrating to SharePoint online but required to login to open the file in dekstop App..it's correct?

Answer 3

Hi NorafifyJalil,

Thank you for the reply.

Your understanding is right. Because SharePoint Online could store Excel macro-enabled (.xlsm) files, however, you can't create, run, or edit VBA macros in Excel for the web. So you need to open these macro-enabled files from desktop app.

And since these files are stored in SharePoint Online, users need to sign in their accounts which have permission to access files from SharePoint Online, so when users open the SharePoint file from desktop app, they will be asked for logging in to verify that whether they have permission to access files in SharePoint.

Best regards,

Jazlyn

Answer 4

Hi Jazlyn, 

I have copy a few macros file from file server to SharePoint Online (Teams Site). This user is using Office 2016. Every time user want to open the macros file in Team site via Dekstop App, it's prompt to login and able to open the macros file in Dekstop App. But the problem is Sign-In information is missing. I've tried to add manually using the same account in Excel 2016 but cannot signed in. Do you have any idea? 

It's true every time you want open macros file via Dekstop App, it's required to login to SharePoint online? because when I tried to open .xls file or other file, the file is successfully open without login to SharePoint online. 

Answer 5

Hi NorafifyJalil,

For the error message, it usually happens when user sign in Office with two accounts which are under same tenant.

Generally, we use personal account (Microsoft account) to activate Office 2013/2016(one-time purchase), and we use work/school account to login SharePoint Online. So may I confirm that whether the account you used for Office 2016 and the account you used for SharePoint Online are under same account?

And how did you assign Office 2016 and SharePoint Online license to these accounts?

Best regards,

Jazlyn