1 Reply Latest reply on Jan 24, 2013 7:25 AM by donjuancarlos_1

    Run an Excel Macro with FM server

    jb_1

      Title

      Run an Excel Macro with FM server

      Your post

           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 ..

           Pleaase help

        • 1. Re: Run an Excel Macro with FM server
          donjuancarlos_1

               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.