Showing tag results for Microsoft Excel

Hey, Scripting Guy! How can I set Office Excel’s default file path to a user’s home directory?-- LL Hey, LL. We hope that the script we’re about to show you will answer your question; if it doesn’t, you might have to wait awhile before we can get back to you on it. That’s because the Scripting Guy who writes this co...

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...

Hey, Scripting Guy! How can I take user names from an Excel spreadsheet, search for those users in Active Directory, and then indicate whether or not each user was found?-- SD Hey, SD. You know, one of the drawbacks to writing a daily scripting column is that people never seem to believe you. For one thing, they don’t believe that you write a dail...

Hey, Scripting Guy! How can I add a bunch of rows to an Excel spreadsheet and then stick a total row at the bottom?-- MW Hey, MW. Could we ask you a favor: is there any chance that you could write back later with this question? As you may or may not know, the University of Washington men’s basketball team is hosting a four-team, round-robin tourna...