I am trying to debug an VBA excel app that invokes some functions from a C++ COM DLL. I have added type library of the COM DDL in Tools--->References. If i build the DLL in debug mode, VBA app complains about not finding the dll at run-time. When i build the DLL in release mode, i am unable to debug it.
Does anyone knows how to link VBA against debug mode COM DLL ?