Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel spreadsheet   (RSS)
Thursday, February 19, 2009 6:15 PM

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

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. However, that does
Posted by ScriptingGuy | 1 Comments
Thursday, January 15, 2009 8:56 AM

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
Posted by ScriptingGuy | 0 Comments
Wednesday, January 14, 2009 8:55 AM

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
Posted by ScriptingGuy | 0 Comments
Monday, January 12, 2009 8:54 AM

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,
Posted by ScriptingGuy | 0 Comments
Thursday, November 27, 2008 8:28 AM

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

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
Posted by ScriptingGuy | 1 Comments
Tuesday, July 01, 2008 11:24 PM

Hey, Scripting Guy! How Can I Summarize Information Found in a Spreadsheet Row?

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
Posted by ScriptingGuy | 0 Comments
Friday, May 30, 2008 10:53 PM

Hey, Scripting Guy! How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?

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
Posted by ScriptingGuy | 0 Comments
Wednesday, March 12, 2008 9:14 PM

Hey, Scripting Guy! How Can I Sort a Spreadsheet By Cell Color?

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. As near as I can tell,
Posted by ScriptingGuy | 0 Comments
Tuesday, February 26, 2008 8:17 PM

Hey, Scripting Guy! How Can I Check the Value of a Specific Cell in a Bunch of Office Excel Spreadsheets?

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? -- RDC Hey, RDC. Now that we’re
Posted by ScriptingGuy | 0 Comments
Wednesday, February 20, 2008 8:11 PM

Hey, Scripting Guy! How Can I Mark the First Occurrence of a Number in an Office Excel Spreadsheet?

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? -- BH Hey, BH. Before we launch into today’s column we have an
Posted by ScriptingGuy | 0 Comments
Tuesday, January 29, 2008 7:28 PM

Hey, Scripting Guy! How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?

Hey, Scripting Guy! I need a script that can read all the values in a spreadsheet and then change the background colors of the cells in that spreadsheet based on a range of values. For example, if the value is less than 20 the cell gets colored one color;
Posted by ScriptingGuy | 0 Comments
Friday, January 18, 2008 6:57 PM

Hey, Scripting Guy! How Can I Search For Values in an Excel Worksheet?

Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet? -- SK Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started
Posted by ScriptingGuy | 0 Comments
Tuesday, December 04, 2007 10:02 PM

Hey, Scripting Guy! How Can I Cut a Row From One Office Excel Spreadsheet and Paste That Row Into Another Spreadsheet?

Hey, Scripting Guy! How can I cut a row from an Office Excel spreadsheet and paste it into the first unused row in another Excel spreadsheet? -- NC Hey, NC. We apologize if today’s column feels a little damp; as it turns out, those of us in the Seattle
Posted by ScriptingGuy | 0 Comments
Monday, October 22, 2007 8:21 PM

Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?

Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isn’t supposed to be a number, it’s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed, convert those
Posted by ScriptingGuy | 0 Comments
Wednesday, October 17, 2007 7:34 PM

Hey, Scripting Guy! How Can I Insert New Rows Above the Last Row in an Office Excel Spreadsheet?

Hey, Scripting Guy! I have an Office Excel spreadsheet in which the last row in the spreadsheet sums all the rows above it. How can I add new rows (and new data) to this spreadsheet, making sure that the last row always sums up all the rows above it?
Posted by ScriptingGuy | 0 Comments
More Posts Next page »
 
Page view tracker