VSTO Copy single worksheet to new workbook without customizations
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
I quickly get my sheet copied to a new workbook but I don't quite how to save it.
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.