iLogic error can not find excel file after saving file as a template

[Anonymous]

I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue. 

I recieve this error:

Error in rule: Material, in document: Part6

'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.

It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder.

Maybe I need a referance to the excel document within the iLogic code. I'm at a loss on this, any suggestions would be welcome.

[Anonymous · Accepted solution]

Additional info that did not get attached

[xiaodong_liang]

hi,

It looks this post was marked as solved by mistake? 

anyway, the original description shows the Excel file cannot be found. Have you tried with absolute path to see if it works? e.g.

MultiValue.List("Material") = GoExcel.CellValues("C:\MWW Materials (Inventor).xlsx", "VP", "A2", "A600")

[Anonymous]

Yes, in this instance when using Vault and creating a template it is necessary to give an absolute path which I have done and solves the problem. The only additional requirement was to add this path as a library in the .ipj. Thanks for your response.