Showing tag results for Office

Hey, Scripting Guy! How can I determine the last row in an Excel spreadsheet? I can’t append data to the file unless I know which row to start with.-- TGW Hey, TGW. You know, this is the kind of thing that separates the Scripting Guys from the rest of the world. Most people would do the same thing you’re doing: looking at their spreadsheet and t...

Hey, Scripting Guy! How can I remove all the formatting from an Excel spreadsheet?-- MT Hey, MT. You know, several years ago one of the Scripting Guys and his family went to the Blizzard Beach water park in Orlando. While there this Scripting Guy went down the Summit Plummet, reputed at the time to be the highest and fastest water slide in the w...

Hey, Scripting Guy! How can I boldface a specific word throughout a Microsoft Word document?-- SB Hey, SB. You’ll probably find this hard to believe, but when you work with scripts and scripting all day you tend to get a little jaded. You say you have a script that automatically backs up and clears all the event logs on all your computers? How n...

Hey, Scripting Guy! How can I get the total number of items - and the total size - of all the items in my Inbox and Sent Items folders?-- CS Hey, CS. You know, one of the Scripting Guys has a foolproof method for determining this information. What does he do? Nothing; instead, he just sits around and waits for the inevitable email from the Excha...

Hey, Scripting Guy! How can I change the font name and size for an entire Word document?-- CD Hey, CD. You know, this question reminded us of how old we Scripting Guys are getting - well, all of us except for Jean, of course, who continues to get younger and more beautiful every day. Note. No, that isn’t really true. However, because Jean’s...