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.
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.
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: