How Can I Password-Protect an Excel Spreadsheet?

Hey, Scripting Guy! In a previous column, you told us a couple different ways to save Excel spreadsheets. In that column, you said that one of the things you could do with the SaveAs method was password-protect a spreadsheet. However, you didn’t show us an example of this. How can I use a script to…

8

How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?

Hey, Scripting Guy! How can I open an existing Excel spreadsheet, add some additional information to that spreadsheet, and then save my changes? Every time I call the SaveAs method a dialog box pops up asking me if I want to save my changes.– RW Hey, RW. Generally speaking, you can avoid that dialog box…

5

How Can I Put the User Name into the Footer of a Microsoft Word Document?

Hey, Scripting Guy! How can I put the user name into the footer of a Microsoft Word document?– RR Hey, RR. That’s an interesting question, and probably the first how-do-I-put-the-user-name-in-the-footer-of-a-Word-document question we’ve ever received. (No, really!) But what the heck; let’s see if we can find an answer for you. Besides, this gives us a…

4

How Can I Save Word Documents as Text Files By Using a Script?

Hey, Scripting Guy! I have a series of Word files. I would like to open each of these files and save them as plain-text files. Is there a way to do that using a script?– CG Hey, CG. Yes, you can do this quite easily with a script; in fact, with very few exceptions anything…

7