Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Excel - Scripting Blog

Hey, Scripting Guy! How Can I Modify the Footers of an Office Excel Spreadsheet?

January 15, 2009 Jan 15, 2009 01/15/09
ScriptingGuy1
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. The Office Excel automation model is documented...

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

January 14, 2009 Jan 14, 2009 01/14/09
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...

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

January 13, 2009 Jan 13, 2009 01/13/09
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 ...

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

January 12, 2009 Jan 12, 2009 01/12/09
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 ...

Hey, Scripting Guy! How Can I Pull Server Diagnostic Information and Have It Saved in an Excel Spreadsheet with a Chart?

November 27, 2008 Nov 27, 2008 11/27/08
ScriptingGuy1
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, I would like the spreadsheet to also create a chart of the results. Is this asking too much? I have seen pieces of all this on the...