Wednesday, April 6, 2011

Excel to CI - Can't find Project or Library

Excel to CI libraries by default  it refer to 'PS_HOME/Excel' directory
This error will due to the, this folder is not reachable for the excel.

If any excel to CI template will give below error. Follow the below steps to solve.

1.



2. Click Ok & go to the Excel press < Alt + F11 > key. It will open Visual Basic Editor.

3. Follow the Screenshot


4. Check the missing library in below screenshot



  5. This RelLangMcro.xla will be located in 'PS_HOME/Excel' folder.

   Copy this file & paste into your current excel to CI folder.

 for eg: the Excel to Ci tmeplate present c:\test. place the missing file in C:\test.

:-)

2 comments:

vamsi krishna said...

very helpful Thanks alot !!

Marcin Tomczak said...

Thank you! That was easy!