XLS references

fjulsing · Post by **fjulsing** » Wed Jul 28, 2004 12:23 pm

In PLE Plus it is possible to use aliasses for XLS files. Menu Model/Settings/XLS.
If the xls file is in the same directory as the model. no path is required.
But: if you use a path other than the modeldirectory, the model only looks in the modeldirectory and returns an error, not able to find the file in the model directory.

The workaround is obvious, the implications are annoying, always having to type thr full path name or alsways moving the xls file to the modeldirectory.

bob@vensim.com · Post by **bob@vensim.com** » Fri Jul 30, 2004 12:31 pm

the answer is yes it is possible to use aliases. You can use relative paths in setting the alias - the path is relative to the directory the emodel is in.

fjulsing · Post by **fjulsing** » Thu Aug 19, 2004 6:50 am

Maybe I wasn't clear: if I have an alias for a file Y:\User\test.xls and the model is in Y:\Models, the program reports an error: 'the file Y:\Models\test.xls does not exist - can't read info'.

Post by **Administrator** » Thu Aug 19, 2004 7:47 am

This is a known problem and should be fixed in the next maintenance release of Vensim.

Tony.