<div>
<div class="content wysiwyg-content">
I have a document-level Excel-based VSTO application written in VB.Net. &nbsp; I would like to take a single worksheet from this application and copy it over to a brand new workbook without any of the VSTO code. &nbsp; I have tried doing a SaveAs on the Activesheet to a specified name and that copies the worksheet to a new workbook with the customization but it is exceptionally slow. &nbsp;Even slower when I use the serverdocument.removecustm<wbr />ization method.<br />
<br />
What I would like to do is to create a new workbook and then copy my singel sheet over and then save it. &nbsp;If I use something similar to this:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim ws As Excel.Worksheet<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws = Globals.ThisWorkbook.Activ<wbr />eSheet<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws.Copy()<br />
<br />
I &nbsp;quickly get my sheet copied to a new workbook but I don't quite how to save it.<br />
<br />
Thoughts and suggestions are appreciated.
</div>
</div>


I have a document-level Excel-based VSTO application written in VB.Net.   I would like to take a single worksheet from this application and copy it over to a brand new workbook without any of the VSTO code.   I have tried doing a SaveAs on the Activesheet to a specified name and that copies the worksheet to a new workbook with the customization but it is exceptionally slow.  Even slower when I use the serverdocument.removecustmization method.

What I would like to do is to create a new workbook and then copy my singel sheet over and then save it.  If I use something similar to this:

            Dim ws As Excel.Worksheet
            ws = Globals.ThisWorkbook.ActiveSheet
            ws.Copy()

I  quickly get my sheet copied to a new workbook but I don't quite how to save it.

Thoughts and suggestions are appreciated.

VSTO Copy single worksheet to new workbook without customizations

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.