View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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