Showing tag results for Microsoft Excel

Hey, Scripting Guy! In Microsoft Excel, how can I display a date like 01/20/2006 using this format: 20060120?-- CM Hey, CM. Who do we make the check out to again? And for how much? Oh, sorry. After attending a parent meeting for the Scripting Son’s new baseball team the Scripting Guy who writes this column naturaly assumes that anyone who asks him...

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! 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! We have an Excel spreadsheet that tracks the status of all our projects. In that spreadsheet the status for a project is indicated by a color assigned to a cell. How can I use a script to determine the color of these cells?-- AE Hey, AE. Just a second; we need to catch our breath. Sorry. Last night the Scripting Guy who write...