Run-time error 9 subscript out of range

[alazar]

Dear Excel forum users,

This is Alazar from Arba Minch university Ethiopia and in a team we are conducting a research study on surface water hydrology using wetspa hydrological model.

In doing this the model has been developed using excel and macros and i tried to follow the installation manual prepared by the developers, however whenever i run the program and click a button to update some worksheets based on the instruction and it is showing me the "Run-time error 9 subscript out of range". I tried to solve the issue by searching online but it is not helping me so i came to your forum seeking for support in fixing the issue. So i attached the file for you to test it and tell me how this issue can be resolved. in order to see the excel file open Oslovak\WetSpa\Model\Output then you will find WETSPA_ANALYSIS_TOOL.xls file and open it, then you will see the main page and click on the update all sheet then the error will come which i can't solve it and needs support on it. So to make all this happen you need to open the macro file and replace the file location according to where you place your file in 14 different lines. If you need any info on how to set up the model you can find it on the official web site ( i can to provide any link because i am new to this forum so please help me to figure out the issue).

Any help to solve this issue will be appreciated and welcomed.

Thanks,

[6StringJazzer]

Your file cannot be tested because the first thing it does it tries to open a file called

C:\Jiri\WetSpa_model\model\output\mean.txt

You did not include this file so an error occurs here and it cannot go further.

[alazar]

Dear Jeff,

Thanks for your answer however i have the file mean.txt inside C:\Users\alazar\Desktop\Oslovak\WetSpa\Model\output\mean.txt ( C:\Jiri\WetSpa_model\model\output\mean.txt) but still the problem exists so what can possibly cause this Run-time error 9 subscript out of range???

For your information i attached you this two images to show the file exists and where the error is pin pointing

file location : mean.JPG
error on micro: error.JPG


Thanks,

[6StringJazzer]

First, I think my point was not clear. I am not saying that your problem has to do with the file mean.txt. But if I do not have the file mean.txt, I cannot run your code and therefore cannot diagnose the problem reliably.

However, looking at the line of code you showed

Please Login or Register  to view this content.

I think what is intended is

Please Login or Register  to view this content.

and for

Please Login or Register  to view this content.

I would use

Please Login or Register  to view this content.

But I can't test this without the file mean.txt.

(Also, the code here is very inefficient. It might work but it looks like it was developed using the macro recorder for guidance, so generates a lot more code than what is necessary. There is too much code for me to try to help with that though.)