Problem with Excel interface and Model reader
Posted: Tue May 19, 2009 11:13 am
Hi,
I'm trying to publish an application with an Excel interface using Vensim 5.8b. I can get everything working using the Model reader to start the .vpa file, thus launching the .xls interface file in Excel and allowing VBA macros to call the DLL, with one annoying problem.
The problem is that when calling MENU>RUN from VBA code, Vensim pops up a dialog asking "Do you want to overwrite the file D:\model.xls with the package file". Since the xls file is already open in Excel, answering Yes gives the error "Unable to overwrite D:\model.xls.", and answering No starts up the simulation alright, with no further errors.
How can I get rid of the dialog window? Vensim shouldn't have any need to overwrite the .xls file since the Model reader has already unpacked the .xls file from the .vpa by this stage.
Any help would be appreciated.
I'm trying to publish an application with an Excel interface using Vensim 5.8b. I can get everything working using the Model reader to start the .vpa file, thus launching the .xls interface file in Excel and allowing VBA macros to call the DLL, with one annoying problem.
The problem is that when calling MENU>RUN from VBA code, Vensim pops up a dialog asking "Do you want to overwrite the file D:\model.xls with the package file". Since the xls file is already open in Excel, answering Yes gives the error "Unable to overwrite D:\model.xls.", and answering No starts up the simulation alright, with no further errors.
How can I get rid of the dialog window? Vensim shouldn't have any need to overwrite the .xls file since the Model reader has already unpacked the .xls file from the .vpa by this stage.
Any help would be appreciated.