XLA not loading the dll

[Chrissirhc]

Hi,

I load an Xla built by someone else and then there are compile errors becauase that readonly xla cannot find the correct dll. But when I uncheck the reference and then do a search for it I find it. How is this possible?

Thanks,

Chris

 

[CBasicAsslember]

When you say "uncheck the reference" are you talking about the reference to the dll or the xla?

 

[Chrissirhc]

I'm talking about the reference to the dll...

 

[CBasicAsslember]

The first thing that comes to mind is checking to see if the xla has declared an absoulute path to the dll which is different from where the dll is located.

 

[Chrissirhc]

It looks like the path the xla declared is the same. However, through trial and error I've just realised its owing to differences in version (Not sure if it is owing to the time stamp or to the actual file). Anyway is there a way to make not care about the version, i.e., just use whatever dll is in the directory with that name??


Thanks,

Chris

 

[CBasicAsslember]

What dll is it using?

 

[Chrissirhc]

Custom made one.

 

[CBasicAsslember]

Try re-registering the dll.

 

[Chrissirhc]

Can't seem to recreate the issue. But I can with an XLS. And it keeps on happening. I have to untick it and then press ok and then I have to find the dll and tick it again.

Is there anyway to make it find the dll in the directory rather than it worrying about the version?

Thanks,

Chris

 

[CBasicAsslember]

Can't seem to recreate the issue. But I can with an XLS.

I have no idea what you mean by this. You can't use a addin without a workbook.

I have to untick it and then press ok and then I have to find the dll and tick it again.

When you say "find the dll" do you mean that you have to browse for it or is it in the reference list?

 

[Chrissirhc]

Ok in the main workbook I can recreate the issue.

When I say find the dll I mean I go to tools --> references in the IDE and then I see that the dll comes up as missing. I have to uncheck it. Close it. Go to tools --> references and then browse for it and then it works.

 

[CBasicAsslember]

You need register the dll.

 

[Chrissirhc]

Registering the dll manually doesn't resolve the issue. Although typically I go to the directory and try registering it...

I'll try registering it with the full path, my gut feel is that it won't work.

Thanks,

Chris

 

[Chrissirhc]

Re-registering with the full path doesn't work. Any ideas on this? Thanks a lot, Chris.

 

[CBasicAsslember]

Unless you can get the correct version of the DLL your out of luck. I assume you can't read the code in the XLA. Is that correct?

 

[Chrissirhc]

The subject in this thread is bad. Sorry.

It should read XLS not loading the dll.

So we have tried

1) Manually reregistering the dll
2) Building the dll (written in VB) with Binary compatibility with the old dll (this keeps the same UID)
3) Building the dll in project mode

None of the above has helped. What is more strange is that XLAs that reference the same Dlls are not having the problem.

I can read the code in both the XLS and XLAs.

This is a very strange problem. Do you know exactly what Excel does when you point it to a DLL in the IDE by using tools --> references? Is it pointing to c:\whereTheFileIs or it looking something up in the registry?

Has anyone experienced this problem with Excel and dlls.

Thanks,

Chris

 

[CBasicAsslember]

Please post the relevant code.

 

[Chrissirhc]

Sorry. There is not relevant code.

The when opening file.xls and hitting alt F11 --> tools - references the reference to the dll comes up as missing.

We don't know why this is and tried the above few things and the suggestions in this post.

Thanks,

Chris

 

[CBasicAsslember]

Add the reference then press F2. From the dropdown box where it says <All librarys> select the dll's library. That will show you the Class objects, methods ect. From there you should be able to locate the parts of the code that use the library.

 

[CBasicAsslember]

When I say find the dll I mean I go to tools --> references in the IDE and then I see that the dll comes up as missing. I have to uncheck it. Close it. Go to tools --> references and then browse for it and then it works.

After you get it working have you saved the xls file then opened it to see if it works?