Hey, Scripting Guy! How can I center text in an Excel cell?-- MV 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 that question; instead, it just seems like we...
Hey, Scripting Guy! In Microsoft Word, how can I change the file locations for User Templates and Workgroup Templates?-- SB Hey, SB. At least one of the Scripting Guys has always had a lifelong fear that he would write, say, the greatest novel ever written, except that no one would know about it or care about it. Well, not until he died, of cour...
Hey, Scripting Guy! How can I insert a Wingding symbol into a Word document?-- RC Hey, RC. In case you’re wondering, there were two reasons why we decided to answer your question. First, we just liked the phrase insert a Wingding symbol. (No, we don’t know why we liked it, we just did.) Second - and by far most important - this is an easy one, o...
Hey, Scripting Guy! How can I change the user information in Microsoft Office to match the user’s name as stored in Active Directory?-- SM Hey, SM. Back in the days when one of the Scripting Guys worked for a local university, every document in one department of 300+ users appeared to have been created by the same person; that’s because a single...
Hey, Scripting Guy! I have a Microsoft Excel spreadsheet I periodically analyze using a script. How can I change the color of a cell to red if the date stored in that cell has passed?-- DM Hey, DM. We were going to start today’s column off with some clever and witty remark about red-letter dates, but we couldn’t actually think of one. Therefore,...
