Can't dereference a missing DLL

  • Thread starter Thread starter Todd Prickett
  • Start date Start date
T

Todd Prickett

I have an Excel spreadsheet that contains a reference to a DLL whose
interface has changed. When I go to references I see the message
"SciDirRoutines.dll Missing". So, I try to uncheck the reference so I
can reference the new DLL. However, after unclicking the check box,
then hitting OK, I get an "error loading DLL" message.

So, I am prevented from removing a reference to a non-existant DLL.

How can I escape this catch 22?

TIA
 
I have used this procedure in the past

1. Copy any dll giving it the name of the missing dll

2. Dereference it (since it should not be called, the different interface should not generate an error)

3. Reference the new dll

4. Remove the "dummy" dll

John H

----- Todd Prickett wrote: ----

I have an Excel spreadsheet that contains a reference to a DLL whos
interface has changed. When I go to references I see the messag
"SciDirRoutines.dll Missing". So, I try to uncheck the reference so
can reference the new DLL. However, after unclicking the check box
then hitting OK, I get an "error loading DLL" message

So, I am prevented from removing a reference to a non-existant DLL.

How can I escape this catch 22

TI
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference to dll object in VBA 4
VBA Reference Missing 1
Windows api code pack DLL 2
Missing References 1
Devolving code to a DLL 4
Remove a missing reference that is in use? 3
Access Access - missing OCW10.DLL 3
unable to load WinSocket dll in Excel Visual Basic Editor 8

Back
Top