Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

How Can I Remove the Password When Opening an Excel Spreadsheet?

(image) Hey, Scripting Guy! How can I remove the password when opening an Excel spreadsheet?-- JE(image) (image) (image) Hey, JE. You know, it’s finally happened: after two-and-a-half years of writing this column we’ve finally run out of things to talk about. The “heartbeat sensor” that can tell you whether someone is hiding in the...

How Can I Import an Excel Spreadsheet Into an Access Database?

(image) Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database?-- IE(image) (image) (image) Hey, IE. Wait! Don’t tell us; let us guess. Just a moment … we’re picking up the vibrations now … the sensation is getting stronger and more distinct … OK, got it: you’d like to know how to import an Excel ...

How Can I Save a Table in an Access Database as a Spreadsheet?

(image) Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet?-- OT(image) (image) (image) Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at least for two of the Scripting Guys. While Scripting Guy ...

How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?

(image) Hey, Scripting Guy! How can I use a blank row to separate rows of data in a Microsoft Excel spreadsheet?-- AR(image) (image) (image) Hey, AR. You know, most people believe that the Scripting Guys all think alike, that we always agree on everything. That’s not true, though; instead, like any other team, we disagree from time-to-...