Scripting Blog

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

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

ScriptingGuy1

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

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

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

ScriptingGuy1

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

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

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

ScriptingGuy1

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