Run an Excel Macro with FM server
My objectif is to export and send mail with a word document (reports), so, I use tihs steps :
1/ Export records to server in an excel files .
2/ When the excel export file will be open automatically in the server , An excel macro will be RUN to save data to a word document. Every line in the excel file will be save in a new document word that will be saved as Line_Name( which is slected in the 2nd column of the line ) .
3/ Now I have the docs and I want to send mail with that attached files , then delete them from the server ..
You can do this:
1) export to a temporary Excel document (Excel1)
2) run a script that opens another excel file with the macro in it (Excel2).
3) have another Macro in Excel2 that imports Excel1 on startup
4) Run the other macro in Excel2
I am doing this to transfer information between FileMaker and some horrible ERP my company wants to use.