?
Solved

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

Posted on 2011-04-20
13
Medium Priority
?
3,225 Views
Last Modified: 2012-05-11
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
Comment
Question by:rberke
  • 6
  • 3
  • 2
  • +1
13 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35431860
Do you have UAC turned on? Are you using 32bit or 64bit Win7?
0
 
LVL 5

Author Comment

by:rberke
ID: 35433098
Yes, UAC is turned on (what a pain.) and I am 64bit
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35433155
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 5

Author Comment

by:rberke
ID: 35433255
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35433327
I'll have a play later on as I don't have Win7 at work yet.
0
 
LVL 14

Expert Comment

by:Matti
ID: 35438270
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
 
LVL 5

Accepted Solution

by:
rberke earned 0 total points
ID: 35442479
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
 
LVL 14

Expert Comment

by:Matti
ID: 35442526
HI!
No UAC here, just that the dll might not work in 7 but the .NET created interop version of it might
Matti
0
 
LVL 5

Author Comment

by:rberke
ID: 35442771
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
 
LVL 29

Expert Comment

by:nffvrxqgrcfqvvc
ID: 35469680

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
 
LVL 5

Author Comment

by:rberke
ID: 35470082
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
 
LVL 29

Expert Comment

by:nffvrxqgrcfqvvc
ID: 35470270
Yes. It wasn't an objec on my behalf it was probrably automated because I posted a comment.
0
 
LVL 5

Author Closing Comment

by:rberke
ID: 35489809
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question