Search results for query: *

Hey Skip Thank you very much for your replies I made a change to the code I already had. rather than putting a comma to separate the numbers in the cell I put the the individual numbers in the next column of that row. it made searching for Duplicates a lot easier. Enjoy your Vacation Skip

Skip Sorry for the late response. What's the business case for this requirement? Maintenance and I'm data collecting from a PLC How many rows of data in your sheet? Max 100 How many possible "duplicates?" ~10 How will specific colors be assigned (relates to the number of possible...

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

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

I'm sorry! I forgot to mention that I am looking for a VBscript example.

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

Tsuji It worked ! Thanks Spaces doesn't matter. My error on first line. there is always a space after ">" Time format is always 18 Characters Fault Description starts after ">" Their just happens to be a Space at the begining of the Fault Description. and time stamp :) " 6-08-10...

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

Thank you Tsuji It worked great! and I agree with your last comment. I am self taught and I am always trying to develop good programming habits.

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