Error in GET XLS CONSTANTS

Use this forum to post Vensim related questions.
Post Reply
Ashish_Kumar
Junior Member
Posts: 17
Joined: Tue Apr 06, 2021 9:31 am
Vensim version: DSS

Error in GET XLS CONSTANTS

Post by Ashish_Kumar »

I attach a model that I have just started working on and the spreadsheet for inputs. I am using GET XLS CONSTANTS. I can read from the "1. Pop" tab of the spreadsheet but not from the "2. AH" tab. I get the error "Failed to connect to Excel...", for example in the variable "AH share of inpatient services".

There's probably a simple thing I am missing. Help is appreciated.
Attachments
CHoF Model.xlsx
(19.45 KiB) Downloaded 82 times
CFoH 0a Stage 2.mdl
(5.56 KiB) Downloaded 91 times
Administrator
Super Administrator
Posts: 4827
Joined: Wed Mar 05, 2003 3:10 am

Re: Error in GET XLS CONSTANTS

Post by Administrator »

The spreadsheet tab name has a space at the end. It's "2. AH ", delete the space at the end and all works fine.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Ashish_Kumar
Junior Member
Posts: 17
Joined: Tue Apr 06, 2021 9:31 am
Vensim version: DSS

Re: Error in GET XLS CONSTANTS

Post by Ashish_Kumar »

Yes, thanks!
Post Reply