Page 1 of 1

Can you make Excel execute a VBA script?

PostPosted: Wed Apr 27, 2011 3:58 pm
by fdekens
Hi,
Once you map the values to an Excel spreadsheet, can you have Excel (automatically) execute a VBA script prior to reading the result values back into MD? The result values I'm interested in are generated using a VBA script, and I don't want to open up the excel file and run it by hand each time in between writing the values, and reading in the results.
Thanks,
Frank D.

Re: Can you make Excel execute a VBA script?

PostPosted: Wed Jul 22, 2015 12:05 pm
by ghassan.issa@nasa.gov
Not that I know of. Paramagic read/write to cells. But what you might be able to do is trigger a macro in vba through a boolean, and have paramagic write a TRUE to a cell to start another function. (Maybe have a function reading a conditional, waiting a a period of time and checking again, it's not ideal, but might be a workaround)