Search results for query: *

Thank you! Changed up the "find last row" thing a bit and it works perfectly! i = 2 ' because I have a column heading If rMatched Is Nothing Then ' Fill the worksheet with the results If CurCell.Value <> "Column Heading" Then With Sheets("Sheet7 Label")...

Code no longer gives error, but doesn't do anything... Sub Compare() Dim active_sheet As Worksheet Dim CurCell Dim CompCell Dim Matched As Variant Dim RealLastRow As Long Set active_sheet = ActiveSheet ' Loop through Sheet 2, column A - every cell that has something in it For Each CurCell In...

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...

Ah-ha! Thanks, Linney. In 3 out of 3 random checks, all instances were domain profiles that no longer existed in our Active Directory. :D

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?

May not be great, but I created two scripts to handle this. Remote_Reboot.vbs reads the list of computers and copies the reboot.vbs script to the computer then launches the script on the remote computer, popping up a msgbox and rebooting the computer when the msgbox goes away (either "OK" or...

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.

This works: =OR(ISNUMBER(SEARCH(Sheet1!B159:B192,E6))) IF you set the formula to an "array" formula by selecting the cell, press "F2" then press "ctrl+shift+enter" It tells me that, yes, at least one cell in b159 thru b192 had a value that was somewhere in the value of cell E6.

Doah! That should be : I want the formula to tell me that a cell in Sheet1!B159:B192 contains a part of the Value of E3 (If a part of b160 is "Jim", or the value of b168 is "Jim", the result is "YES") I would suppose that ISNUMBER is used because search returns the number of the character the...

From the Excel Help: Check if part of a cell matches specific text To do this task, use the IF, SEARCH and ISNUMBER functions. Note The SEARCH function is case-insensitive. Formula Description (Result) =IF(ISNUMBER(SEARCH("v",A2)),"OK", "Not OK") Checks to see if A2 contain the...

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...

... you know, maybe I should have asked before, but if you go to the add/remove programs and uninstall it, does it work there? Also, try using the uninstall string from the registry in the command window - does it uninstall correctly then?

Here is an example of what I've done to remove Winzip : '******************************************************************* Function RemoveWinZip(strPCName) WScript.Echo "Funtion RemoveWinZip has been called for " & strPCName LogFile.WriteLine strPCName & ",beginning Remove Process" ' Based...

Ah... going to http://bmcserver:port/ and using the .hta as the default "home page" did not work. However, if I made a default .html page and put a link to the .hta in there, clicking on that link does launch the .hta properly and throws up a nice "Security Warning" dialogue that asks the...

Yes, the .hta will work if they could doubleclick the .hta directly from their desktop. Unfortunatly, they will probably have to access it from a url resembling : http://bmccmserver1:someport/ Which will use IE to open it and will not just run the .hta and that is where my problem comes in. ...

No, an Intranet site is "internal" and limited to access from our company's network, with no outside access. Secondly, the information gathered and displayed will be specific for the one computer currently accessing the page - dynamic content tailor made for the person/computer viewing the...

Yeah, I wrote an HTA that would do it, thing is, the way its called, it opens inside a browser window, not the normal way an HTA opens itself. Users will "Link" to a URL and it will open the "Default Page" which I can make a .HTA, but it won't open it as a local html application, it will be a...

Yes, we have BMC Configuration Manager for software deployment. Trying to get BMC's 'User self service' working, which is total and complete access OR a custom HTML page displaying only the links to software we want them to be able to "self load". We're opting for custom. The "What version...

LOL.. thing is I AM responsible for the security on the computers that I am needing this information from to display. Basically security is THE reason I need to do this. It will be a self-service software page that will tell the end-user what version of software they have and then show them the...

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...