Hello, I am relatively new to Linux and especially to BASH scripting... need some assistance doing the following:
I need a script that utilizes journalctl to evaluate the kernel’s error and warning logs twice on a Debian system, at 30 sec intervals, uses diff to compare the two files, and...
I need to write a PS script that outputs process tree with child processes nested under the parent processes. It needs to identify all processes with no parent processes as the root for the trees.
I am NOT a PS programmer, not even a little bit so I need assistance please. Found some...
This is apparently a spreadsheet that he is trying to modify for his purposes. If you scroll down to row 10, where you can see the merged cells that show the dates, 4/28 would be 3 cells from the left where 25 April starts.
You can remove the conditional formatting, again that was a residual...
He's not tech savvy so I am asking on his behalf... trying to help him out. Yes, obviously I have more initiative to get the problem solved.
If the value in the ACTUAL END column is greater than the Projected End (which then the value in the days overdue column would be a negative value) - he...
Hi everyone, I have a friend that is trying to use an Excel template to track a project he's working on. He does NOT have access to Microsoft Project, so he's having to use Excel instead.
He's trying to show the overdue time period on the Calendar and in RED in the following Excel spreadsheet...
Should put a screenshot on here so you could see what I see in the Word document then. Weird stuff been going on today. Will have him test this next week.
Thank you for your help. :-)
Oh what is going on there WERE some terms in there...
When the macro was run, it wasn't highlighting the terms in the word document in the different colors, it was only using one color. So this should work the way it is coded then?
Well that may be the case, but there are different terms in each spreadsheet (didnt reuse them on purpose), see:
test document: http://files.engineering.com/getfile.aspx?folder=d15025f5-7283-405c-b976-bec8d7e51392&file=macrotest.docx
spreadsheets being used...
Tried doing what you suggested, created a separate macro for each one (see below). It's not changing color like it should between each of them, all of them are highlighted the same color.
Sub RescindedJointTerms()
Dim xlApp As Object, xlWkBk As Object, StrWkBkNm As String, StrWkSht As String...
He asked me a followup question: Can it look to four different spreadsheets and use a different highlight color? (and if so, I need to know how to do this, please) your help is greatly appreciated
These are the requested spreadsheets and their colors:
I have: Rescinded Army Terms: Highlight...
His comments:
This Macro is perfect! Not what I asked for, but I love the Comment addition to my request. I can Also use this Macro for a multitude of other applications.
So, thank you so much for your help and I am sorry he kept changing his requirements.
Alright, this is what he said and I sincerely apologize for him not being clear in what he wanted/needed:
need both words on the document (the original word that we were calling the "rescinded term")... I'm not replacing the words. I'm showing a suggestion. It's up to the original author to...
I thought you were going to say that and that is exactly what I told him - that isn't what he asked for... I didn't know if it would be an easy fix or not, which is why I asked. Thank you so much for getting back to me on this. I will find out from him...
Still just need to know how to do this if it is possible please:
He wants to know if there's a way so that the "rescinded word" doesn't get deleted, just is highlighted like it is now, so he can decide whether it needs to be deleted or not before it actually shows up as deleted in track changes...
Well unfortunately he doesn't have time to really learn this, he's trying to get this done for a job he has to complete, but thanks for the suggestion. He's not a programmer...
He wants to know if there's a way so that the "rescinded word" doesn't get deleted, just is highlighted like it is now, so he can decide whether it needs to be deleted or not before it actually shows up as deleted in track changes.
As he put it: "... I need the original word to stay not be...
WOW, thank you SO MUCH!!!!!!!! It does exactly as he wanted... you are awesome. (I tested it) He's out of the office for a couple of days so I will have him test it when he gets back and let you know if there are any issues, but I don't anticipate that there will be. THANK YOU AGAIN, SO...
He is using track changes, he wants to know how to create the macro to highlight the word that is being replaced and then also already have the word that SHOULD replace it right there, highlighted as well that way he doesn't have to refer to the list every time he needs to find/fix a phrase in a...
My friend said this: I have a laundry list of rescinded words and phrases that I have to search for. Was hoping to already have the associated replacement word there. We live in track changes here... That why I was asking for the format in macro.
SO, if the macro recorder isn't what is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.