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.
I am quoting by memory from another post not uploaded by me so I can share this info but cannot do more:
If you can setup your macro to run automatically when the file is opened, FileMaker can use Send Event to open that File--and thus trigger the Excel Macro to run.