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.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.