Showing tag results for Office

Hey, Scripting Guy! How can I add a new item to Office Word’s AutoCorrect list?-- OK Hey, OK. To begin with, we should point out that we have no way of knowing whether your initials really are O and K; after all, they could just as easily be TR, and you could actually be Tony Romo, quarterback of the Dallas Cowboys, writing to us under an ...

Hey, Scripting Guy! How can I clear all the formatting from a Microsoft Word document?-- TF Hey, TF. After a much-deserved holiday hiatus we are back, with the first official Hey, Scripting Guy! column for the year 2007. And yes, we know: technically we did have a column yesterday. As it turns out, however, that column was actually written a few...

Hey, Scripting Guy! How can I list all the Access database files (.mdb and .ldb files) on a computer?-- MG Hey, MG. You know, in this day and age most people don’t believe in Santa Claus. Well, we happen to know that these people are wrong: Santa Claus really is real. How do we know that? Because he’s spent the past couple days spamming the Script...

Hey, Scripting Guy! In Excel, how can I compare a list of names found in one column with a list of names found in another column?-- GS Hey, GS. You know, in general we Scripting Guys are charged with presenting people with facts; in turn, we’re really supposed keep our opinions to ourselves. However, sometimes there are things that just have to be...

Hey, Scripting Guy! How can I convert a tilde-delimited file to Microsoft Excel format?-- JN Hey, JN. You know, to tell you the truth we’re beginning to rethink our approach to this column. After all, usually we tell people how easy things are, and how – without much effort – they can write a script that will let them accomplish some seemingly-imp...