AnsweredAssumed Answered

How do I run an Excel Macro from FMP

Question asked by gschnider on Feb 9, 2015
Latest reply on Feb 10, 2015 by philmodjunk


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.