Showing tag results for Excel.Application

Nov 8, 2006
Post comments count0
Post likes count0

How Can I Create a Custom Date Format in Microsoft Excel?

ScriptingGuy1
ScriptingGuy1

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

Scripting Guy!VBScriptOffice
Nov 1, 2006
Post comments count0
Post likes count0

How Can I Keep the Screen From Updating While Running an Excel Script?

ScriptingGuy1
ScriptingGuy1

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

Scripting Guy!VBScriptOffice
Oct 30, 2006
Post comments count0
Post likes count0

How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?

ScriptingGuy1
ScriptingGuy1

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

Scripting Guy!VBScriptOffice
Sep 8, 2006
Post comments count0
Post likes count0

How Can I Use Windows PowerShell to Automate Microsoft Excel?

ScriptingGuy1
ScriptingGuy1

Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce you to Windows PowerShell. Those are all th...

Scripting Guy!Windows PowerShellOffice
Jun 27, 2006
Post comments count0
Post likes count0

How Can I Copy a File Numerous Times and Rename Each of Them from a List in Excel?

ScriptingGuy1
ScriptingGuy1

Hey, Scripting Guy! How can I copy a file 150 times and then rename each of those copies using a list of names found in an Excel spreadsheet?-- DF Hey, DF. You know, when we first started this column 2 years ago (must be time to mention the 500th Hey, Scripting Guy! celebration again) our biggest concern was this: what are we going to do if no o...

Scripting Guy!VBScriptWMI