1 Reply Latest reply on Feb 10, 2015 4:28 PM by philmodjunk

    How do I run an Excel Macro from FMP



      How do I run an Excel Macro from FMP


      I'm using FMP 13 Advanced. I also have FM Server 13. I'm using Excel 2013 on a Windows 8.1 machine. 

      An Excel document exists on my local hard drive, but I can put it anywhere (server,container field etc...) if needed. I export data to the Excel document and then run a Macro from within Excel to perform certain necessary actions. I've looked through forum posts, but there doesn't seem to be a real solution to this. Some people have suggested using the Send Event command. 

      Does anyone have any experience with this? Could you possibly shed some light on it for me? I would be willing to compensate for services if you're on Odesk, but you must be 100% sure that you've been there and done that.