Can you make Excel execute a VBA script?

Discussions about ParaMagic functionalities

Moderator: Moderators

Can you make Excel execute a VBA script?

Postby fdekens » Wed Apr 27, 2011 3:58 pm

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.
fdekens
Forum Newbie
Forum Newbie
 
Posts: 14
Posts Rating:2
Joined: Tue Apr 20, 2010 11:46 am

Re: Can you make Excel execute a VBA script?

Postby ghassan.issa@nasa.gov » Wed Jul 22, 2015 12:05 pm

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)
ghassan.issa@nasa.gov
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Wed Jul 22, 2015 11:54 am


Return to ParaMagic

Who is online

Users browsing this forum: No registered users and 3 guests