Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year.
Hey, Scripting Guy! I have a simple question for you: How can I modify the footers in an Office Excel spreadsheet?
I have a simple answer for you as well. You assign a value to the appropriate footer property of the pagesetup object.
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,
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,
Hey, Scripting Guy! Good morning. I would like to use WMI to get diagnostic information for my server. I would like to be able to do this remotely and to write the results to an Excel spreadsheet. When I am done,
Hey, Scripting Guy! I have an Excel spreadsheet that tracks daily time for our employees, indicating whether the employee worked on a given day or took some type of leave (paid leave, leave without pay, sick leave, etc.). Is there a way to output a report showing the various leave types taken by each employee,
Hey, Scripting Guy! We have quite a large collection of speeches and audio training sessions that are sorted by … well, by nothing. However, all the ID3 tags [the file’s extended data] are up-to-date. Is there a way to extract the ID3 information from these files into an Excel spreadsheet?—
Hey, Scripting Guy! We have an Excel spreadsheet in which we use different colors as a way to track status information. That works out really good for us, except for one thing: sometimes we’d like to sort the spreadsheet by color.
Hey, Scripting Guy! How can I create a script that will list all the files in a directory that have a specific value in a specific cell of an Office Excel workbook? And can that be expanded into a find/replace function?
Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help?
Hey, BH. Before we launch into today’s column we have an announcement to make: the Scripting Guys surrender.