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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find duplicates in a column and change text color
I am trying to find duplicates in a column and change the font color The column is text formatted some cells have one number others have multiple numbers separated with a comma and space can anyone help in writing a macro to do this ? example below Thanks |2 | |13 | |2...- zoodaddy
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Please Help batch file find a specific word and show word on next line
I need to find a word (which would be %username%) in a text file and then display the next line (which would be the users name) Text file ex. N123456 44 Nameof User0 N123457 44 Nameof User1 N123458 39 <---- Find N123458 which is %Username% Nameof User2 <---- then echo the... -
Checking if an Excel Spreadsheet is open by an other User on network
Hi I know how to check if an Excel application is open on the computer that is being used. Set colprocesslist = _ objWMIService.ExecQuery("Select * from Win32_Process Where Name = 'Excel.exe'") But how do you find out if a spreadsheet is open on a network server and what user has it... -
Delete Duplicate Line Function that Ignores 1st 18 Characters
I Need a Delete Duplicate Line Function that will Ignore the first 18 Characters of each line I have found many and excellent examples in deleting the whole line but can't figure how to filter the 1st 18 characters. Example below is from a Log.inf file showing that the first 3 lines repeat but... -
OnMouseOver in VBScript IE Button Menu
Hello ! First Time asking for help online. I have put together a simple VBScript to create an IE Menu that when a button is pressed it passes an Argument to a cmd file. I am trying to figure out how to use OnMouseOver and OnMOuseOff Event in my script to change the button color when mouse is...
