ब्लॉग कोशिश कर रहा है بلاگز کی ک*Trying Blogs

[DocAElstein]

Some additional notes on things broken ActiveX controls..
These are just some additional notes in support of other Forum Threads on the Theme of things “broken by / with ActiveX controls”
http://www.excelfox.com/forum/showth...en-insert-them
http://www.excelfox.com/forum/showth...ommand-Buttons
http://www.excelfox.com/forum/showth...0586#post10586

List of, and search of Updates on Computer:

Often one hears that updates can cause problems with things “Activia X y controlly” . This Post considers ways to automate seeing what you have and checking for particular ones reported to have given problems with ActiveX controls…….
( Actually what we are doing here is to get a list of updates on a computer and / or search through/ for them. So this post may be of general interest when looking for any updates on a computer ).
Old black box command Dosy Window looking at Files stuff
Getting a window up that looks like an old black screened computer up and typing simple old computer type commands seems to be what one often uses when delving into these sort of things, so that is a good start point.. ( I think this window thing is possibly similar to the console Window thingy in Visual Basic https://www.mrexcel.com/forum/genera...ml#post4357648 )
Get it up
From Hans here: http://www.eileenslounge.com/viewtop...=28682#p222044
http://www.eileenslounge.com/viewtop...=28682#p222044

_ Press _ Windows key + r _ to activate the Run dialog
Windows+r.JPG : https://imgur.com/1KI8nok
cmdInBoxBar.JPG

_ Type in box bar _ cmd _ if not already shown
cmdInBoxBar.JPG : https://imgur.com/L9saGzj
Windows+r.JPG

_ Press _ Ctrl+Shift+Enter _ to start an "elevated" command prompt.
ElevatedCommandPrompt.JPG : https://imgur.com/W1p6frJ
ElevatedCommandPrompt.JPG

Get a list of Updates in a text file
Note: In the following steps you need to type a few things in exactly as given. I have sometimes experienced problems with characters not working and / or pasting in not working. But usually one or a combination of the following will work
_ (i) If you are lucky you can type all characters.
_ (ii) Copy text from here and paste in using _ Ctrl+v
_ (iii) Copy text from here and past in using _ option given when clicking right mouse
_ To get a text file produced, for example on your desktop, type in a single code line something like these examples , using a file path to suit you:

 wmic qfe get hotfixid > C:\Users\Elston\Desktop\UpdatesOnVistaAspire4810TZG25thMarch.txt 
wmic qfe get hotfixid > C:\Users\Alan\Desktop\UpdatesAcerMartinWin7Pro64Bit26thMarch.txt

It may take a few seconds, and then you should see a text file appear ( in this case it appeared on my desktop because I put that path in ) looking something like this : https://imgur.com/9Ze2FY6
Here is the first part of the text file on one computer.

HotFixID                                
{EF8CD7FC-438D-49E3-A2C7-201052D9F2EF}  
{8D2CDFAB-0079-43CC-A289-2F7A67F0A4DE}  
{98D8F490-1F42-4F29-A59B-BF96D23A11BA}  
{B730F010-3FCF-4E80-8A5A-C1DBEC0CF55A}  
{B73E5AF4-40C6-4EA9-8F57-CFA70CC72BD6}  
{BF11577A-6876-45AA-86C9-2BA4CFB8B019}  
{E359D786-B101-4545-B8AB-8652323CF3CA}  
{F4139440-5426-4C6F-909B-F71CEB1071B1}  
{B2FAD7E1-67F9-435D-98BD-A77DBF4E1381}  
{0CC8FAD2-05D8-4A0A-9E5C-2CDACFF86996}  
{0EF0D4FB-BB23-4515-AAEA-1240AC2DA525}  
{800D1A82-D1B0-4ED4-89B4-C666B570ABA5}  
{8D2CDFAB-0079-43CC-A289-2F7A67F0A4DE}  
{98D8F490-1F42-4F29-A59B-BF96D23A11BA}  
{BF11577A-6876-45AA-86C9-2BA4CFB8B019}  
{E359D786-B101-4545-B8AB-8652323CF3CA}  
{F4139440-5426-4C6F-909B-F71CEB1071B1}  
{B73E5AF4-40C6-4EA9-8F57-CFA70CC72BD6}  
{D6C976E4-E88C-4048-9A6B-39400D2933C7}  
{FC8EA2A2-65A3-366E-A687-5B63943A800F}  
{6F8500D2-A80F-3347-9081-B41E71C8592B}  
{AC76BA86-7AD7-0000-2550-7A8C40011010}  
{FC8EA2A2-65A3-366E-A687-5B63943A800F}  
{D758F295-2DE9-4A95-B857-B18BF52A26B2}  
{E94DDFCD-6D84-40A4-B5DF-24AE25761924}  
KB971513                                
KB971512                                
KB982861                                
982861                                  
KB960362                                
942567                                  
KB971514                                
KB2761494                               
KB2079403                               
KB2117917                               
KB2141007

Here is the uploaded text file obtained from a couple of my computers
“UpdatesOnVistaAspire4810TZG25thMarch.txt” : https://app.box.com/s/z90o8yj7iz0188yci34mu7gahe2tfhce
“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt” : https://app.box.com/s/8m96l0e7yh1wcb15y06eaaz6a7vtjzgd

It would be nice to automate that . I Don’t know how
Never mind. In any case you should now be able to get a list

Search the list for specific updates updates
A few ways…
( A way without using the text file )
_ use the command like : _ wmic qfe get hotfixid | find "KB1234567"
If KB1234567 is installed, you'll see KB1234567 on the next line, otherwise it'll remain blank. : http://www.eileenslounge.com/viewtop...=28682#p222044
https://imgur.com/9Ze2FY6

( Ways using the text file )
_ Knacker your eyes looking through the text file
_ You may be able to do a simple search with your text editor. Using Notepad I can get a search from the following options from the top of the open editor window of something like __
--- Bearbeiten --- Suchen
or
---- Edit --- Search
or
using the shortcut key combination __ Ctrl+f
You then have a search window in which you can type in what you want to find
Note however: I think there are sometime some strange characters that are not always visible to you, and then a search may fail as it won’t make a perfect match possibly. I am not too sure exactly what I mean there, but others have told me some quirky things can happen such that that text search fails…
The next way can help over come that ###

_ It can easily be automated to search the text file using VBA. I prefer to do this mainly as it is less likely for me to make a mistake, but also as I have found some strange characters coming in to dirty/corrupt the string of the update, and the search can be done for a match on part of the string which will help offset the problem of missing a match due to the string corruption ###
Here is a simple code.
Sub CheqUpDates()
http://www.excelfox.com/forum/showth...0586#post10586
You input the Updates that you want to search for with one or more spaces in between, and you can type in just part of the character string. All matches will be returned in a string in a message box, and also that string is available to be copied from the immediate window.