Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

January 2009 - Page 3 of 4 - Scripting Blog [archived]

Hey, Scripting Guy! How Do I Run an Office Excel Macro on Multiple Workbooks?

January 13, 2009 Jan 13, 2009 01/13/09
ScriptingGuy1
(image) 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. While this is not normally a ...

Hey, Scripting Guy! How Can I Add a Function to an Office Excel Spreadsheet?

January 12, 2009 Jan 12, 2009 01/12/09
ScriptingGuy1
(image) 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 many rows of data I will have. Also, I am not sure how to add...

Hey, Scripting Guy! How Can I Configure the Cmd Console via the Registry?

January 8, 2009 Jan 8, 2009 01/8/09
ScriptingGuy1
(image) 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 a new machine, I need ...

Hey, Scripting Guy! How Can I Change My Internet Explorer Home Page?

January 7, 2009 Jan 7, 2009 01/7/09
ScriptingGuy1
(image) Hey, Scripting Guy! I just found out that Internet Explorer 7 and even Internet Explorer 8 Beta 2 allows you to have multiple home pages. This is like soooo cool. I would like to be able to write a script that uses Windows PowerShell to change the start page to the Script Center. It would be nice if I could do this remotely, but that...

Hey, Scripting Guy! How Can I Modify Registry Settings That Configure Windows Explorer?

January 6, 2009 Jan 6, 2009 01/6/09
ScriptingGuy1
(image) Hey, Scripting Guy! Why does it feel like every single default setting in Microsoft Windows is wrong? It is so frustrating to me to spend five minutes changing all the defaults. For example, I open Internet Explorer and there are no system files. I look at files, but there are no file extensions. The names of text files that I put in...