Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel.Application   (RSS)
Friday, June 27, 2008 11:20 PM

Hey, Scripting Guy! How Can I Prevent Office Excel From Turning My Imported Numbers Into Dates?

Hey, Scripting Guy! I have a CSV file, and every time I open that file in Office Excel my numbers get converted to dates. How can I import numbers as numbers? -- JR Hey, JR. You know, just yesterday the Scripting Guy who writes this column learned about
Posted by ScriptingGuy | 0 Comments
Thursday, May 01, 2008 2:21 PM

Hey, Scripting Guy! How Can I Change the Value and Color of a Spreadsheet Cell Based on the Sum of Other Cells in That Spreadsheet?

Hey, Scripting Guy! I’m new to Excel, and I was wondering how to change the color of a cell if specific requirements are met. I have a spreadsheet that has three columns of numbers; I’d like to add the numbers in each row and, if they total 100, set the
Posted by ScriptingGuy | 0 Comments
Monday, April 14, 2008 10:07 PM

Hey, Scripting Guy! How Can I Import a Fixed-Width Data File into Microsoft Excel?

Hey, Scripting Guy! How can I import a fixed-width data file into Microsoft Excel? -- RS Hey, RS. This column is being written on a Friday morning, and so far it’s been a very weird morning at that. For one thing, it’s not raining and – if you look closely
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
Thursday, November 01, 2007 9:12 PM

Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10? -- MJdR Hey, MJdR. You know, just a few days ago word leaked that a Federal Emergency Management Agency (FEMA) press conference held to discuss the US government’s
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
Tuesday, September 11, 2007 10:59 PM

How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files? -- BR Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch as
Posted by ScriptingGuy | 0 Comments
Tuesday, September 04, 2007 10:52 PM

How Can I Add a Background Picture to an Excel Worksheet?

Hey, Scripting Guy! How can I add a background picture to an Excel worksheet? -- GA Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his
Posted by ScriptingGuy | 0 Comments
Monday, June 04, 2007 8:28 PM

How Can I Copy Selected Columns From a CSV File to an Excel File?

Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file? -- MdP Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time
Posted by ScriptingGuy | 0 Comments
Tuesday, May 29, 2007 8:20 PM

How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row? -- GL Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because
Posted by ScriptingGuy | 0 Comments
Tuesday, May 01, 2007 6:34 PM

How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet? -- NN Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was
Posted by ScriptingGuy | 0 Comments
Monday, February 12, 2007 9:47 PM

Hey, Scripting Guy! How Can I Configure Office Excel to Autosave Every 5 Minutes?

Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes? -- KK Hey, KK. You know, that’s a good question. As it turns out, the autosave capability in Microsoft Excel – hey, wait a minute: do you realize what day it is? Today is
Posted by ScriptingGuy | 0 Comments
Thursday, February 08, 2007 9:42 PM

Hey, Scripting Guy! How Can I Save an Office Excel Chart as a Picture?

Hey, Scripting Guy! How can I save an Office Excel chart as a picture? -- JB Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes
Posted by ScriptingGuy | 0 Comments
Wednesday, January 31, 2007 9:34 PM

Hey, Scripting Guy! How Can I Change the Font Color in Office Excel If a Specified Condition is Met?

Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10? -- EP Hey, EP. You know, before the Scripting Guy who writes this column started
Posted by ScriptingGuy | 0 Comments
Thursday, January 25, 2007 9:28 PM

Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?

Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML? -- KE Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for
Posted by ScriptingGuy | 0 Comments
More Posts Next page »
 
Page view tracker