Showing tag results for Office

Hey, Scripting Guy! How can I add a COUNTIF formula to an Excel spreadsheet?-- MF Hey, MF. Thanks for reminding us: yes, we are getting closer and closer to the actual 500th Hey, Scripting Guy! Celebration. Note. There was a bunch of stuff here about the celebration, but it’s over now so we took it out. That should explain the small gap in...

Hey, Scripting Guy! How can I get a list of the unique words used in a Microsoft Word document?-- RK Hey, RK. Funny you should mention unique words. Last Saturday the Scripting Coach’s baseball team played in the city championship. Despite the importance of the game the team was missing two key players, and the Scripting Coach knew that meant th...

Hey, Scripting Guy! How can I copy all the comments from an Excel worksheet to a Word document?-- ED Hey, ED. You know, one of the drawbacks to calling yourself a “Scripting Guy” is that people assume you’re really more of a Scripting Fanatic. Every now and then we get emails that say, “Hey, Scripting Guy! I read your column on X. Well, I do X a...

Hey, Scripting Guy! How can I write a script that accesses all the subfolders in my Outlook Inbox?-- MB Hey, MB. You know, after you’ve written a daily scripting column for nearly two years (have we mentioned the Hey, Scripting Guy 500th column celebration lately?) you learn that certain subjects are strictly off-limits. Discuss religion in a sc...

Hey, Scripting Guy! How can I get a list of available metadata for Microsoft Office documents?-- JR Hey, JR. If we understand your question correctly, you’d like to know if it’s true that July 21, 2006 will mark the 500thHey, Scripting Guy! column; in addition, you’d like to know whether we are planning to do anything to mark th...