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

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

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

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