Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel.Application   (RSS)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
More Posts Next page »
 
Page view tracker