Forum Discussion

Reiner Burton's avatar
Reiner Burton
Copper Contributor
Jul 17, 2017

Macro in Excel on Sharepoint Online do not work

Hi, I'm using Office 365ProPlus and have added a macro to my excel sheet to determine the last save date of this excel XLSM file. (using FileDateTime) On my local PC this works as designed.   Aft...
office 365
sharepoint
  • Adris_Shirzad's avatar
    Adris_Shirzad
    Copper Contributor
    Jun 06, 2019

    Pieter Veenstra, do you think this was helpful for running Excel-Macro into sharepoint, coz i haven't find something related to his question?

  • Reiner Burton's avatar
    Reiner Burton
    Copper Contributor
    Jul 17, 2017

    Thanks for the quick response.

    I learned now that it doesn't work with Excel online at all.

    What's about local Excel with a file located in Sharepoint Online ? Should this work ?

    Cheers

    • Pieter Veenstra's avatar
      Pieter Veenstra
      MVP
      Jul 17, 2017

      It worked for me.

       

      When you recorded your macro where did you store it?

      • ptstockley's avatar
        ptstockley
        Brass Contributor
        Oct 14, 2020

        Pieter Veenstra I am having a similar problem, which of the 3 locations would be best to store the macro?

        My gut says that keeping it 'local' and "This Workbook" would be the best location. Do you agree?

Resources