Showing tag results for Office

Hey, Scripting Guy! I seem to recall that there’s a way to “freeze” the display in Microsoft Excel any time you carry out a lengthy operation; that way the user doesn’t see anything change until the operation is complete. Do you have any idea how I can do that?-- IW Hey, IW. Do we have any idea of how you can do that? Oh, IW, you’ve cut us to the ...

Hey, Scripting Guy! How can I rename a bunch of folders using a script? The old folder names are in the first column of an Excel spreadsheet and the new folder names are in the second column of an Excel spreadsheet.-- SF Hey, SF. Oh, and welcome to Hey, Scripting Guy!, your daily source for scripting information. We’d like you to know that Hey, ...

Hey, Scripting Guy! How can I center-align a picture in a Word document?-- CD Hey, CD. In light of the controversy surrounding World Series game 2 (was Detroit Tigers pitcher Kenny Rogers throwing “goopballs” or wasn’t he?) the Scripting Guys felt it was important to note that no illegal substances were used in the writing of today’s Hey, Script...

Hey, Scripting Guy! I have approximately 100 Excel files (all with names like 9365.xls) in a folder. I’d like to prompt a user for a file name, open the file, retrieve information from a specified cell, then close the file (ideally Excel would never appear on screen). I’d then like to prompt the user to enter another file name. How can I do that?...

Hey, Scripting Guy! Over the past year or so you’ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?-- ME Hey, ME. Let’s see, what time is it? OK good: we have enough time to answer this question and get the column posted. We were a little...