Hey, Scripting Guy! I have a problem. I am trying to script the backup of a data folder used by our database application. The problem is that as long as the database service is running, the files that are used are locked, and I am unable to copy them. I have found the service that…
Year: 2009
Hey, Scripting Guy! How Do I Display a Message and the Time a Process Was Terminated?
Hey, Scripting Guy! We have this application that is supposed to run all the time. It is constantly giving us headaches and crashing. The applications vendor evidently expects it to crash all the time and has a thread that will restart it three times. After that, it is pretty much down for the count. The…
Hey, Scripting Guy! How Can I Be Notified When a Process Begins?
Hey, Scripting Guy! I need to be notified when a process begins. I would like to use Windows PowerShell to do this, but it does not seem to work. While I could do this in VBScript, I prefer to use Windows PowerShell. Can this be done?- NL Hi NL, Because we have access to the…
Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/16/09)
How Do I Set Process Affinity? Hey, Scripting Guy! I have this application that I would like to set process affinity for. I know I can use Task Manager, right-click the process, and choose to set affinity, but I would like to be able to do this from a script. Can this be done?…
Hey, Scripting Guy! How Can I Modify the Footers of an Office Excel Spreadsheet?
Hey, Scripting Guy! I have a simple question for you: How can I modify the footers in an Office Excel spreadsheet?- MN Hi MN, I have a simple answer for you as well. You assign a value to the appropriate footer property of the pagesetup object. If you would prefer a longer answer, read on….
Hey, Scripting Guy! How Do I Center Contents of a Column in Office Excel?
Hey, Scripting Guy! When I add data to an Office Excel spreadsheet, it always seems to put stuff on the right side of the column. I would like to know how to center the contents of a column. I do not think it should be that hard, but I just cannot figure it out. -…
Hey, Scripting Guy! How Do I Run an Office Excel Macro on Multiple Workbooks?
Hey, Scripting Guy! I don’t know about you, but I love Microsoft Office Excel macros. Come Valentine’s Day, my computer gets a card. Office Excel macros save me so much time, it is just unbelievable. There is just one problem, and that is that I have to open Office Excel and manually run the macro….
Hey, Scripting Guy! How Can I Add a Function to an Office Excel Spreadsheet?
Hey, Scripting Guy! I need to add some data to an Excel spreadsheet. After I have done that, I would like to add a function to the bottom that will add up all the information in the columns above that. I have seen examples of plugging data into cells, but I do not know how…
Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/09/09)
How Can I Tell the Status of Services on a Computer? Hey, Scripting Guy! I’m wondering if you can help me before I tear all my hair out. I’m trying to write a script using WMI that checks for a few core services such as antivirus, remote desktop software, and the like. The intention…
Hey, Scripting Guy! How Can I Configure the Cmd Console via the Registry?
Hey, Scripting Guy! You know, it just dawned on me that Windows PowerShell uses the old-fashioned Fred Flintstone cmd console for its host application. Because this thing has been around forever, are there any registry settings I can use to configure this beast? The reason I am asking is that every time I go to…