Running macro in Excel file saved on SharePoint site?

Hi all,

I am wondering if it is possible to run a macro on an xltm file that is saved on a SharePoint site. Specifically, I'd like to upload the xltm, have a user add data, save the changes, and then run a macro that creates multiple new xlsx documents that need to be saved on the same SharePoint site. This would be easy to do locally, but I am skeptical that it will work the same way on SharePoint. Is this possible? If it is, do I structure the code in the same way I would if I were doing the task locally, or will I run into all sorts of security permissions problems? If it needs to be written differently, what do I need to know?

Thanks!

Anyone know about this?