Excel Error (Can't find project or library)

vkn2220
Hi All,
I am getting above error. Missing reference is DotNet Library for Kite Connect API. Does anyone know how to fix this error? I installed KIteNet. Placed all dll files. But somehow couldn't fix it. Any help is highly appreciated.
  • HowUTrade
    HowUTrade edited September 2019
    @vkn2220

    Pls follow the below steps;
    1. Open a new Excel sheet, Disable Macros and Close Excel (no need to save the blank sheet)
    2. Open your KiteNet Excel workbook.
    3. Go to VBA editor
    4. In VBA Editor, go to Menu --> Tools --> References
    5. Remove References - DotNet Library for Kite Connect API and Excel Tools for Trading (if exists) and close the references window (Ref attached image1)
    6. Again open references window - Menu --> Tools --> References
    7. Add References - DotNet Library for Kite Connect API and Excel Tools for Trading (if exists) and close the references window (Ref attached image2)
    8. Compile VBA - Menu --> Debug --> Compile VBAProject (Ref attached image3)
    9. save and close your excel workbook
    10. Open a new Excel sheet, Enable Macros and Close Excel (no need to save the blank sheet)

    Now you can work with your KiteNet excel workbook.

    Image1:


    Image2:


    Image3:
Sign In or Register to comment.