I have a question about using Excel as an interface to a commercial simulation program. (gPROMS)
Excel interface is used as a data provider and output reader. The problem is, when i want to change a value of a cell (to change the input data for the simulation), or just press enter to make a new entry to any cell in the Excel chart the simulation stops at my simulation program until i give a new value and press enter again. And if i don't give a quick new entry, simulation terminates itself.
Some macros have been used to make this Excel interface.
My question is; is there any easy way to prevent this simulation stop during data update in my chart? Or is the only way to write another macro?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.