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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- BKearan
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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?- BKearan
- Thread
- Replies: 3
- Forum: Microsoft: Windows
-
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. -
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...- BKearan
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
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... -
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... -
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... -
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...- BKearan
- Thread
- Replies: 0
- Forum: Enterprise Management
-
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... -
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... -
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... -
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... -
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...
