• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3382
  • Last Modified:

how to extract vba object properties in windows 7. tlbinf32.dll no longer works

Under Windows XP, I could enumerate the properties of an object using tlbinf32.

But, it does not seem to work under windows 7.

Is there a different (and hopefully better) way to do this under windows 7?

Here is what goes wrong with tlbinf32.


When I use Excel IDE to try to set a reference to tlbinf32, I cannot find it in c:\windows\system32\TlbInf32.dll

But, when I browse to it using windows explorer, it is there.

when I try to reregister it using >regsvr32 c:\windows\system32\TlbInf32.dll

I get this error message:

                                                           
The module "c:\windows\system32\TlbInf32.dll" failed to load.
Make sure the binary is stored at the specified path or debug
it to check for problems with the binary or dependent .DLL    
files.                                                        
The specified module could not be found.                      
                                                   
0
rberke
Asked:
rberke
  • 6
  • 3
  • 2
  • +1
1 Solution
 
Rory ArchibaldCommented:
Do you have UAC turned on? Are you using 32bit or 64bit Win7?
0
 
rberkeConsultantAuthor Commented:
Yes, UAC is turned on (what a pain.) and I am 64bit
0
 
Rory ArchibaldCommented:
tlbinf32.dll is listed as an unsupported file on this page: http://msdn.microsoft.com/en-us/vbrun/ms788708
so I suspect you might be out of luck.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
rberkeConsultantAuthor Commented:
Could be out of luck.  But, unsupported just means "dont call us we won't help".  Often unsupported stuff works if you can figure out how to tweak it.

So, I will leave this question open for a while in hopes someone can help.
0
 
Rory ArchibaldCommented:
I'll have a play later on as I don't have Win7 at work yet.
0
 
MattiCommented:
Try in Vista64 and if you a lucky to mak an interop control from that dll there us it or try to make that interop in XP but use app target x86 then

Reference this file in .NET

Matti
0
 
rberkeConsultantAuthor Commented:
Matti, this is a dll, not an exe so the compatibility option is not available.

But, I moved the dll out of c:\windows\system32 and put it into c:\myfolder\tlbinf32.dll.  At first blush it seems to work fine there.  I did a regsvr32 and it worked, and Excel can reference it properly.

I don't have time to give it a real workout now, but I will post back in  day or so.

Some sort of magic about UAC ??
0
 
MattiCommented:
HI!
No UAC here, just that the dll might not work in 7 but the .NET created interop version of it might
Matti
0
 
rberkeConsultantAuthor Commented:
I would like to know where one gets a .NET created interop version of a dll like tlbinf32 that is not supported?

At the moment I don't think it really matters because my workaround seems fine. But, I am quite ingnorant on .NET so I am looking forward to your answer.

0
 
nffvrxqgrcfqvvcCommented:

Right click the command prompt and choose Run As Administrator then point to : C:\Windows\SysWOW64\RegSvr32.exe

That is the 32 bit version of RegSvr32
0
 
rberkeConsultantAuthor Commented:
Eql1044:  sorry, that will not help, and it turns out I don't really need any help.

On 4/25 I solved my own problem, and accepted my own answer with a comment clearly stating the reason why my answer was the best. EE rules gives a 4 day (maybe 5?) waiting period giving previous commenters a chance to object.  

Unfortunately, your answer came during that 4 day waiting period, and you probably just missed the fact that I had answered my own question.

I never noticed this before, but my closing comments did not get the familiar Gray Bar that accompanies all my other comments. Instead, EE buries my reasons in the fine print at the end of the thread.

In the future on those rare occasions when I accept my own answer, I will post a normal comment first so that casual observers don't waste their time.
0
 
nffvrxqgrcfqvvcCommented:
Yes. It wasn't an objec on my behalf it was probrably automated because I posted a comment.
0
 
rberkeConsultantAuthor Commented:
I've done some testing and it works fine as long as it is installed in a folder that I created, rather than a system folder.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now