Scripting Blog [archived]

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

How Can I Copy and Rename a Worksheet in the Same Workbook?

(image) 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(image) (image) (image) Hey, JG. Of course you can do this; after all, if you can do something in Excel it’s almost 100% ...

How Can I Save a Single Excel Worksheet to a CSV File?

(image) 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 (image) (image) (image) Hey, SS. You know, you just have to love Excel. Yes, we know, to be “cool” these...

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

(image) 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(image) (image) (image) Hey, RW. Generally speaking, you can avoid that dialog box by ...