Showing archive results for 2007

Hey, Scripting Guy! I have some extremely large Office Excel worksheets, and I need to insert a blank row every 240 lines; in that new row I then need to insert a formula that calculates the average of the preceding 240 rows. As you might expect, this is extremely tedious, and I have a lot of these worksheets. How can I write a script that insert...

Hey, scripting Guy! I have about 5,000 text files that have unwanted tabs at the end of each line. How can I write a script that removes these unwanted tabs?-- TT Note. If this looks – and sounds – a little different than the typical Hey, Scripting Guy! column, well, there’s a good reason for that: that’s because it is a little different th...

Hey, Scripting Guy! I’ve been testing your script for saving all the attachments in your Outlook Inbox, and it works great. However, I have a question: is it possible to get this script to run only against new emails?-- CN Hey, CN. Welcome to today’s Hey, Scripting Guy! column, brought to you on-location from the La Quinta Inn in beautiful downt...

Our phone numbers are stored in Active Directory as extension numbers; however, we have a set of rules for converting those extensions to actual phone numbers. I’m writing a script to create an Outlook signature, but in that script I need to be able to convert an extension to a phone number. How do I do that?-- SM Hey, SM. You know, you are look...

I recently read an article of yours that showed me how I can retrieve the names of all the tables in an Access database, along with a list of all the fields in each table and the data type of each of those fields. That’s a really useful script, but it would be even more useful if it could list the field size and also display a sample record for e...