Jul 17 2017 05:46 AM
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.
After uploading the file into sharepoint in the cloud, I have two option
Does anybody know how I can get Excel to work properly with Macros if the file is stored in the cloud ?
Thanks Reiner
Jul 17 2017 05:49 AM
Excel Online doesn't support running Macros:
Jul 17 2017 06:48 AM
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
Jul 17 2017 07:04 AM
It worked for me.
When you recorded your macro where did you store it?
Jun 06 2019 12:56 PM
@Pieter Veenstra, do you think this was helpful for running Excel-Macro into sharepoint, coz i haven't find something related to his question?
Oct 13 2020 11:04 PM
@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?
Oct 14 2020 07:29 AM
@ptstockley Running Excel Macros is at least questionable. You could look at using Power Automate with running scripts in Excel. This is something that is still very new and in Preview but it could be interesting.
For more on this please have a look at the following post:
https://sharepains.com/2020/07/21/run-script-with-excel-in-power-automate/