Showing results for Microsoft Excel - Scripting Blog [archived]

Hey, Scripting Guy! I’d like to copy one of the worksheets in an Excel workbook and then paste that copy into the very same workbook; once it’s pasted it, I’d like to rename it. Can I do that?-- JG Hey, JG. Of course you can do this; after all, if you can do something in Excel it’s almost 100% guaranteed that you can do it using a script. This i...

Hey, Scripting Guy! I’d like to be able to open an Excel spreadsheet, get all the information off one of the worksheets, and then save that worksheet data to a comma-separated values file. How can I do that?-- SS Hey, SS. You know, you just have to love Excel. Yes, we know, to be “cool” these days you’re supposed to say th...

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 password-protect a spreadsheet?-- MC Hey, MC. W...

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 by using the Save method rather than the ...