Automation Error: The system cannot find file specified
Hi,
I am using Microsoft Excel Professional Edition 2003. I am accessing methods in a .Net dll by referencing its tlb in the macro of the excel. The tlb is created while building the .Net solution by selecting the "Regoister for COM Interop" option in the project properties. Both the dll and excel file have been undergoing changes and working perfectly for over six months. But since yesterday (after changing some code in the excel macro and referencing the newly build tlb), I am getting "Automation Error The system cannot find specified file." The method to create the tlb hasnt changed. I am at a loss as to why this error is occuriing. Any help in this regard is welcome. Regards, Shilpa |
Automation Error: The system cannot find file specified
Assuming the file is in the correct location and it compiles to a valid DLL
for use Excel, at a guess, is broken Binary Compatibility an issue ? NickHK "Shilpa" wrote in message ... Hi, I am using Microsoft Excel Professional Edition 2003. I am accessing methods in a .Net dll by referencing its tlb in the macro of the excel. The tlb is created while building the .Net solution by selecting the "Regoister for COM Interop" option in the project properties. Both the dll and excel file have been undergoing changes and working perfectly for over six months. But since yesterday (after changing some code in the excel macro and referencing the newly build tlb), I am getting "Automation Error The system cannot find specified file." The method to create the tlb hasnt changed. I am at a loss as to why this error is occuriing. Any help in this regard is welcome. Regards, Shilpa |
Automation Error: The system cannot find file specified
yes, both your assumptions are right.
Could you please explain broken binay compatilbility? Solution for the same will be highly appreciated. "NickHK" wrote: Assuming the file is in the correct location and it compiles to a valid DLL for use Excel, at a guess, is broken Binary Compatibility an issue ? NickHK "Shilpa" wrote in message ... Hi, I am using Microsoft Excel Professional Edition 2003. I am accessing methods in a .Net dll by referencing its tlb in the macro of the excel. The tlb is created while building the .Net solution by selecting the "Regoister for COM Interop" option in the project properties. Both the dll and excel file have been undergoing changes and working perfectly for over six months. But since yesterday (after changing some code in the excel macro and referencing the newly build tlb), I am getting "Automation Error The system cannot find specified file." The method to create the tlb hasnt changed. I am at a loss as to why this error is occuriing. Any help in this regard is welcome. Regards, Shilpa |
Automation Error: The system cannot find file specified
http://developer.kde.org/documentati...atibility.html But this is more an issue with .Net/Interrop than Excel. NickHK "Shilpa" wrote in message ... yes, both your assumptions are right. Could you please explain broken binay compatilbility? Solution for the same will be highly appreciated. "NickHK" wrote: Assuming the file is in the correct location and it compiles to a valid DLL for use Excel, at a guess, is broken Binary Compatibility an issue ? NickHK "Shilpa" wrote in message ... Hi, I am using Microsoft Excel Professional Edition 2003. I am accessing methods in a .Net dll by referencing its tlb in the macro of the excel. The tlb is created while building the .Net solution by selecting the "Regoister for COM Interop" option in the project properties. Both the dll and excel file have been undergoing changes and working perfectly for over six months. But since yesterday (after changing some code in the excel macro and referencing the newly build tlb), I am getting "Automation Error The system cannot find specified file." The method to create the tlb hasnt changed. I am at a loss as to why this error is occuriing. Any help in this regard is welcome. Regards, Shilpa |
All times are GMT +1. The time now is 04:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com