Multiple Table Excel Import problem

I use Multiple Table Excel Import tool.

When I set Absolute Path of Excel files, it works. But if I set relative path, it doesn't work. The error is showed in the attachment. How to solved?

Thanks

I use Vista Chinese edition, Excel 2003 Chinese edition, flexsim 4.52

Zhang,

I looked into the code and it appears that there was a change in one of the functions in 4.52 that has broken the ExcelAuto object in the library. I have let the development group know about the problem so it will be fixed in the next release. If you want it fixed now you can do so by changing line 86 in the import() cppfunction of the ExcelAuto object in the library to the following two lines:

bookname = concat(cdir(), bookname);
filename = apchar(bookname);

You will have to compile the entire session after making the change and the change would not save with the model so you would have to make the change everytime you opened the model. I know that this is not a reasonable solution; I only mention it so that you can see where the problem is coming from yourself.

Anyway, I do appologize that this is a problem. It will be fixed for the next release.

Brandon

Oh, It's a pity. I have made a model for a user. He only has flexsim demo version to run the model. He always wants me to correct this.

Oh, I get it.
you can write the following sentence in a reset event to set the path of excel file.

setnodestr(node("/Tools/ExcelAuto>variables/importtable/1/1", model()), concat(modeldir(), "my.xls"));

But I have another problem, why the following doesn't work?
stringreplace(modeldir(),"AssignIn\", "")