Showing tag results for Office

Mar 13, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Sort a Spreadsheet By Cell Color?

ScriptingGuy1

Hey, Scripting Guy! We have an Excel spreadsheet in which we use different colors as a way to track status information. That works out really good for us, except for one thing: sometimes we’d like to sort the spreadsheet by color. As near as I can tell, however, Excel doesn’t let you sort a worksheet by color. Could a script help me out here?-- G...

Scripting Guy!VBScriptOffice
Feb 26, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Check the Value of a Specific Cell in a Bunch of Office Excel Spreadsheets?

ScriptingGuy1

Hey, Scripting Guy! How can I create a script that will list all the files in a directory that have a specific value in a specific cell of an Office Excel workbook? And can that be expanded into a find/replace function?-- RDC Hey, RDC. Now that we’re finally beginning to get a bunch of scores posted for the 2008 Winter Scripting Games peopl...

Scripting Guy!VBScriptOffice
Feb 25, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Find a Word in a Document and Change the Background Color of the Paragraph Where That Word Appears?

ScriptingGuy1

Hey, Scripting Guy! I have a bunch of reports and log files that are saved as Microsoft Word documents. I’d like to be able to search for a specific word in one of these documents (e.g., the word “Failed”) and then change the background color of any paragraph that the target word appears in. How can I do that?-- XD Hey, XD. You ...

Scripting Guy!VBScriptOffice
Feb 21, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Set a Reminder on All My Office Outlook Appointments?

ScriptingGuy1

Hey, Scripting Guy! My manager does not like appointment reminders; therefore every meeting request she sends is without reminders.  I like reminders and I try to remember to turn them on, but sometimes I forget; that means that if I'm not on top of my schedule, I can miss a meeting. How can I write a script that will go through all my m...

Scripting Guy!VBScriptOffice
Feb 20, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Mark the First Occurrence of a Number in an Office Excel Spreadsheet?

ScriptingGuy1

Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help?-- BH Hey, BH. Before we launch into today’s column we have an announcement to make: the Scripting Guys surrender. You have beate...

Scripting Guy!VBScriptOffice