FYI - I was having a related problem in Word VBA in Office 2007 where my Reference to Visual Basic for Applications was to C:\WINDOWS\system32\MSVBVM60.DLL but it couldn't resolve basic library functions like UserForm.Show vbModeless and thus couldn't compile. To resove I changed the following registry key:

HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\6.0\9\win32

From: C:\WINDOWS\system32\MSVBVM60.DLL
To: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL