Showing results for Excel spreadsheet - Scripting Blog [archived]

Hey, Scripting Guy! As part of a demonstration I do on a regular basis, I’d like to be able to open an Excel spreadsheet, copy all the information on Sheet 1, and then paste that data into a new PowerPoint slide. How can I do all that using a script?-- JG Hey, JG. You know, the Hey, Scripting Guy! column is always written the day before it’s pub...

Hey, Scripting Guy! I have an Office Excel document that includes a hyperlink linked to an email address. The text in the spreadsheet simply says Yes. How can I write a script that retrieves the underlying email address?-- AK Hey, AK. You’ll have to forgive us for being a little distracted today. Today is Thursday, October 11th, the day that the...

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! How can I open an Excel spreadsheet, update all the links to other Excel spreadsheets, and then break those links?-- YH Hey, YH. Before we begin, we’d like to make an announcement: the Scripting Guy who writes this column gives up. To tell you the truth, that’s not something we ever expected to say; after all, the Scripting G...

Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files?-- BR Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch as the Washington Huskies dismantled Boise State 24-10, snapping the Bronco’s nation’s-best winnin...