Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Microsoft Excel - Scripting Blog [archived]

How Can I Import a Fixed-Width File into Microsoft Excel?

November 17, 2005 Nov 17, 2005 11/17/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I import a fixed-width file into Microsoft Excel?-- JP(image) (image) (image) Hey, JP. We have a confession to make here, something we’re terribly ashamed of: for a moment - just for a moment, mind you - we doubted Microsoft Excel. Yes, we know: how could we do such a thing? All we can say is that we ...

How Can I Build an Array from a Column of Data in Excel?

October 12, 2005 Oct 12, 2005 10/12/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I build an array from a column of data in Excel?-- AH(image) (image) (image) Hey, AH. Obviously none of the Scripting Guys has any need to go on a diet (perish the thought!), but we do know that one time-honored dieting strategy is the theory of tiny bites: instead of gulping down your food in a few huge...

How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?

September 20, 2005 Sep 20, 2005 09/20/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP(image) (image) (image) Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then press Ctrl+V. There you go, and thanks for your question. Oh, ...

How Can I Center Text in an Excel Cell?

September 12, 2005 Sep 12, 2005 09/12/05
ScriptingGuy1
(image) Hey, Scripting Guy! How can I center text in an Excel cell?-- MV(image) (image) (image) Hey, MV. You know, every now and then we get asked a question and we think to ourselves, “Wow, how many times do you suppose we’ve answered this question?” And, of course, when we go to double-check we find out that we’ve never answered ...