View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike McNeill Mike McNeill is offline
external usenet poster
 
Posts: 3
Default Registry Location for References in VBe

Thanks for looking at this Nick -
I should have put more detail in there!! I am using Windows XP Pro and
Office 2000.

The specific .TLB file is present in the "correct" folder and I have
replaced it with the original supplied by the parent application from CDROM.

Just run dependency check on the TLB file and get "Error....not a valid 32
bit or 64 bit module". Also same error for older TLB files (for the same
application) that I know have referenced correctly in the past.

The path to this file has always shown correctly in the Reference window
(and referenced correctly) until the file was moved and path broken.
Firstly trying to reload it via the Browse button from its new path gave no
change and subsequently a runtime failure to recognise a specific referenced
class.
Then after a close and reopen with a workbook that has run these macros
correctly in the past, the same runtime error occurred and the path shown
for the TLB file in Tools - References was now the path for the workbook;
there wasn't a TLB file there.

That is where I am at, with seemingly no way of removing or repairing this
reference. I recall that in the past, somebody explained where the entries
were in the Registry and paths could be corrected in there. Unfortunately I
did not make a note of the Key and now cannot locate it!

Some earlier posts suggested using VBA code for the VBE application to
overwrite the reference and then activate it, but my early attempts to do
this have failed with error messages.

Any further help would be greatly appreciated
Thanks again - Mike


"NickHK" wrote in message
...
Mike,
You could try checking if any of the dependencies of that references are
missing.
Get Dependency Walker, http://www.dependencywalker.com/.

NickHK

"Mike McNeill" wrote in message
...
Does anyone know which key in the Registry key holds the references for
DLL's and TLB's?

I'm still trying to repair a broken Reference and cannot get rid of it.
It
will not accept a "Check" and gives "Error in loading DLL" message.

Can you help with this please Tom Ogilvy? It looks as tho' you have
worked
on this topic before!!
Thanks in advance
Mike