Showing results for Excel spreadsheet - Scripting Blog [archived]

Jul 2, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Summarize Information Found in a Spreadsheet Row?

ScriptingGuy1
ScriptingGuy1

Hey, Scripting Guy! I have an Excel spreadsheet that tracks daily time for our employees, indicating whether the employee worked on a given day or took some type of leave (paid leave, leave without pay, sick leave, etc.). Is there a way to output a report showing the various leave types taken by each employee, along with the dates those leaves we...

Scripting Guy!VBScriptOffice
May 31, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?

ScriptingGuy1
ScriptingGuy1

Hey, Scripting Guy! We have quite a large collection of speeches and audio training sessions that are sorted by … well, by nothing. However, all the ID3 tags [the file’s extended data] are up-to-date. Is there a way to extract the ID3 information from these files into an Excel spreadsheet?-- FB Hey, FB. You know, here at Scripting Guys World Hea...

Scripting Guy!VBScriptOffice
Mar 13, 2008
Post comments count0
Post likes count0

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

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