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