Showing archive results for 2009

Jan 14, 2009
Post comments count0
Post likes count0

Hey, Scripting Guy! How Do I Center Contents of a Column in Office Excel?

ScriptingGuy1
ScriptingGuy1

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. - LK Hi LK, Did you try Open Sesame? I can certainly sympathize with you. It can be r...

Scripting Guy!Windows PowerShellOffice
Jan 13, 2009
Post comments count1
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 problem, it just be...

Scripting Guy!Windows PowerShellOffice
Jan 12, 2009
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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

Scripting Guy!Windows PowerShellOffice
Jan 8, 2009
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 to right-clic...

Scripting Guy!Windows PowerShelloperating system
Jan 7, 2009
Post comments count0
Post likes count0

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

ScriptingGuy1
ScriptingGuy1

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 is not a hug...

Scripting Guy!Windows PowerShellscripting techniques