Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BKearan
  • Content: Threads
  • Order by date
  1. BKearan

    Excel - compare sheet2.colums(1) to sheet7.colums(1) write to sheet6

    Total Newb to VB for Applications. I've got an Excel 2007 spreadsheet that is Huge and I am manually sorting a lot of stuff. Functions have failed me. I need Code! I'm familiar with VBScript and AutoIt3. As the subject states, I need to compare Sheet2, Column 1, Cell 1 to every cell in...
  2. BKearan

    Numbers in Admistrator's Group

    I am seeing serial numbers? in my Administrator's Group. Anyone know what or why? ie: S-1-5-21-1173626634-1814065488-618671499-11687 S-1-5-21-1173626634-1814065488-618671499-13456 S-1-5-21-1173626634-1814065488-618671499-1711 Basically, is it very safe to remove them?
  3. BKearan

    Maybe silly

    How can I get a pop-up to show on a remote computer? Need to reboot a few hundred computers, showing the user a box and waiting until they click "OK" to actually reboot.
  4. BKearan

    How/Can I do this Formula in Excel 2007?

    Trying to compare part of a cell to a column of text. =IF(ISNUMBER(SEARCH(Sheet1!B159:B192,E3)),"Yes","No") The above does not work, but I think it gets the intent across. If I replace "Sheet1!B159:B192" with "jim" and E3 contains "Jack Jimbo" I would get a "Yes". I don't want to limit the...
  5. BKearan

    Annoying Problem

    I am needing to pull information about File/Program versions from a computer opening a intranet webpage. Of course, Internet Exploder won't allow VBScript to run WMI queries. Basically I am needing to get something like : <html> <head> <SCRIPT language="vbscript" type="text/vbscript" > Sub...
  6. BKearan

    Odd Output Problem

    All of a sudden my scripts started having this problem. I used logfile.writeline to output to an opened for writing csv file. It was working fine. No changes to script. Then... well, I start getting this: Computername1 ???????????? Computername2 ???????????????????? Computername2...
  7. BKearan

    objService.Change returns 21

    I have a service that I need to script to set a user name and password for. When opening it is says something about the device associated with it does not exist. When scripting to change the user name and password, it returns error 21, device not ready ( I think ). How can I get around this and...
  8. BKearan

    Silent Uninstall of Winzip

    Got everything working, but get a : "wzshlext.dll is in use by another process" error when trying to uninstall (via script AND via add/remove). The dll is in use by the Explorer process... so can't kill the process to free it up. Even using regsvr32 to unregister gets an error about it was...
  9. BKearan

    FULL Active Directory Search

    Problem : Our Active Directory implementation is... er.. crap. The OU structure is loose, complicated and not followed very well. So, computers are in all kinds of OUs and from what I can tell, some computers are not in any... I need to do a FULL search of the domain, but, just getting the...
  10. BKearan

    Error 0x80041002

    Getting an Error: 0x80041002 Code: 80041002 Source: (null) in scripts on some computers (not others). here is a snippit strPCName = "." Dim objWMIService, Err, objProcess, strShell, objProgram, searchkey Dim strDisplayName, strDisplayVersion, strUninstall, strUninstallf Dim subkey, oReg...
  11. BKearan

    Why is this NOT working??

    Got a script that goes out to a list of targets and pulls the uninstall registry info... it gets the Uninstall and it's subkeys and returns those fine... BUT, I need to pull DisplayName, DisplayVersion and UninstallString from each subkey. From everything I've googled and read, the following...
  12. BKearan

    Logon Screen Error Stops VBScritp Cold

    I run VBScripts on around 3200 computers at a time. Mostly, they work fine. But, if a computer is sitting at the log-on screen and has any error (usually "at least one service failed to start") AT the log-on screen, the script stops at that computer and does not continue - even with the On...
  13. BKearan

    LDAP User Info Pull

    The Goal: Pull in user logon Ids from a text file and then pull information about them from Active Directory. The Script: ' Find information from Active Directory using the logon name '----- Customize the following constants for your needs ----- Const HostList = "targets.txt" Const...

Part and Inventory Search

Back
Top