export data from a worksheet to a NEW workbook

[sandal]

Hi all,

I have code that transfers data from a worksheet a user selects to a new workbook, which allows the user to use the data as they please without corrupting the master spreadsheet. This works fine on my computer, but users are accessing this spreadsheet off a document archive system so they run into problems... My first thought would be to get rid of the .SaveAs line of code but would appreciate some expert opinion as I have to release this live and cannot error check myself.

The code is as follows:

WhichSheet is a worksheet variable based on the user's selection
WSName is a string variable which holds the name of the worksheet the user selected
ExportWorkbook is a workbook variable for the newly created spreadsheet

Please Login or Register  to view this content.

Any help is kindly appreciated

[sandal]

Well I bit the bullet and took out the .SaveAs line. This seems to have worked and has the added bonus of decreasing execution time by 2 1/2 seconds too! I wonder if there is any value to the With ExportWorkbook code at all...?