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
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