input from and output to excel

stevenijones · Post by **stevenijones** » Mon Sep 24, 2007 2:07 pm

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

stevenijones · Post by **stevenijones** » Mon Sep 24, 2007 2:09 pm

excel sheet

bob@vensim.com · Post by **bob@vensim.com** » Tue Sep 25, 2007 11:32 am

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.

stevenijones · Post by **stevenijones** » Fri Sep 28, 2007 10:31 am

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?