Showing tag results for VBScript

Hey, Scripting Guy! I have a script that automatically creates a Microsoft Office Word table that features several columns of data. At the bottom of each column I need to list the largest number that can be found in that column. What’s the easiest way to determine the largest value in each column in a table?-- GL Hey, GL. Great question. Here's ...

Hey, Scripting Guy! I have a folder filled with invoice files. Each of these files has been given a file name based on a specific three-part naming convention: a three-letter abbreviation of the vendor name; the invoice date (e.g., 06032008) ; and the invoice number (which can be of varying length). In other words, all the files have names like t...

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

Hey, Scripting Guy! I have a folder with scores of Word documents in it. What I need to do is open each document, copy anything that uses the Heading 1 style, and then write that information (the file name and anything that uses the Heading 1 style) to a single text file. Is there a way to do this using a script?-- DN Hey, DN. You know, there ha...

Hey, Scripting Guy! In Microsoft Outlook if you sort and group your email by date, you don’t just get groupings that show the date; instead, you get groupings like Today, Yesterday, Last Week, etc. I’d like to do something similar; I’d like to look at the last-modified date for all the files in a folder, then report back that date as one of the f...