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.
Error in GET XLS CONSTANTS
-
- Junior Member
- Posts: 17
- Joined: Tue Apr 06, 2021 9:31 am
- Vensim version: DSS
Error in GET XLS CONSTANTS
- Attachments
-
- CHoF Model.xlsx
- (19.45 KiB) Downloaded 82 times
-
- CFoH 0a Stage 2.mdl
- (5.56 KiB) Downloaded 91 times
-
- Super Administrator
- Posts: 4827
- Joined: Wed Mar 05, 2003 3:10 am
Re: Error in GET XLS CONSTANTS
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- Junior Member
- Posts: 17
- Joined: Tue Apr 06, 2021 9:31 am
- Vensim version: DSS
Re: Error in GET XLS CONSTANTS
Yes, thanks!