Scripting Blog [archived]

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

March 30, 2005 Mar 30, 2005 03/30/05

ScriptingGuy1

(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?

March 22, 2005 Mar 22, 2005 03/22/05

ScriptingGuy1

(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?

January 31, 2005 Jan 31, 2005 01/31/05

ScriptingGuy1

(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 ...