Showing tag results for Office

Hey, Scripting Guy! How can I build an array from a column of data in Excel?-- AH 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 swallows, you nibble at it with scor...

Hey, Scripting Guy! How can I determine which version of Access was used to create an Access database?-- TW Hey, TW. You know, at least one of the Scripting Guys is a bit old-fashioned, to say the least. He doesn’t own a cell phone, and he won’t use drive-through windows. He wears his baseball hat forwards rather than backwards (!), and he absol...

Hey, Scripting Guy! How can I set Word’s default file location to be the user’s home directory?-- LD Hey, LD. Ah, memories. There was a period of time when it seemed like every question we answered in this column was a two-part question: we’d always find ourselves doing things like showing people how to do task 1 (retrieve the user’s home direct...

Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP 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, right: you wanted to know how to do thi...

Hey, Scripting Guy! How can I open Word with the cursor positioned at the start of a specified line?-- PS Hey, PS. You know, we Scripting Guys have decided that we don’t like Microsoft Word anymore. How come? Well, as Scripting Guys we like to find solutions to seemingly-unsolvable problems: any time we can find a workaround for something that l...