Bugs with GET XLS SUBSCRIPT?

[pav80]

Colleagues,

Please see attached document that discuss perhaps two bugs that I have found with the Vensim command GET XLS SUBSCRIPT?
Or perhaps I am doing something incorrectly.

VensimIssue.docx

(41.02 KiB) Downloaded 309 times

Thank you for any advice.

[tomfid]

Note this warning in the help for the function:

Lastcell can be left blank '' with GET DIRECT SUBSCRIPTS but this will generally not work with GET XLS SUBSCRIPTS.

The empty ' ' entry for the last cell argument might be the problem.

Thanks for the good documentation - we'll look into this - I've had some annoyances with the file pointing behavior as well.

[pav80]

TOMFID thanks for the reply.
I had noted that but at the same time on

http://www.vensim.com/documentation/ind ... script.htm

it states

"You can substitute named Excel ranges for 'firstcell'. In this case 'lastcell' is ignored."

Since I am using a named range in Excel for firstcell, hence, I kept last cell blank with '' since anyways it is ignored.

The bizarre thing is that all works just fine if one runs Vensim manually but the moment you employ automated script the issue appears.

All the best

[tomfid]

Right - so I guess your 'Vensim_PYEAR' points to a range, not a single cell?

I think we'll have to look at the code to see what's going on.

Does your Excel procedure use DDE or the DLL?

[pav80]

Yes 'Vensim_PYEAR' points to a range, not a single cell.

Excel procedure uses DDE.

All the best