Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1381
  • Last Modified:

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
            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.
0
AddOnsInc
Asked:
AddOnsInc
1 Solution
 
AddOnsIncAuthor Commented:
I guess I should have performed a few more searches because I found the perfect solution at http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/779c42b4-f298-4dbd-af3b-39784b04ae78

0

Featured Post

Visualize your virtual and backup environments

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now