Ventana software support forum

Hi

I've been having some problems with input and output from excel. I've got a model which reads in data from excel using get xls constants. It works fine.

I've also got some excel VB which will run the model and exports the data from vdf to xls. It works fine too, but when the model runs from excel (happens to be the same sheet as the input data) it does not pick up the new data to run the model with.

I've attached the model and spreadsheet.

Appreciate any help.

Steve

excel sheet

I am guessing that you are using an older release of Vensim. GET XLS CONSTANTS used to use DDE to communicate with Excel and this doesn't work when called from Excel. Try updating to 5.7 and see if the problem persists.

Thanks Bob,

Stopped me banging my head against what could be a brick wall! I've asked my management whether upgrading is possible and for now I am using a hyperlink in excel to a command script file which works fine but isn't quite as flexible as I can't change the names of the run, save list and excel output without editing the text file.

Anybody got another way of doing this?