AnsweredAssumed Answered

Import data into an Excel document and run the macro inside of it from FMP

Question asked by dwirony on Sep 26, 2018

I've got an Excel document where I typically pull an export from FMP, paste the results into an Excel template and then run a macro which imports all the data from Excel into a website. Basically I'm wondering if I can setup a script of some kind to run the export from FMP, take my resulting export and bring it into this Excel file, then call the macro by name - is this outside of FMP's scripting functionality?


In a perfect world, I'd like to just import into this website directly from FMP, but they don't have an API and I can't achieve it through web viewer.