[AccessD] OT: Excel - Get sheet out of workbook

IN EXCEL 2K3  
     RIGHT click on the TAB --> 
     select MOVE or COPY ---->
     TO BOOK --- > drop down select (NEW book) ---> 
     check mark CREATE A COPY this will save original and make a new
copy

     bingo new workbook with one sheet
     


**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, July 19, 2007 10:27 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] OT: Excel - Get sheet out of workbook
> 
> I have a workbook with 4 sheets.  I need to get those four 
> sheets out into separate workbooks (one sheet per workbook).  
> Other than copying the file four times and deleting the 
> sheets not wanted, is there a way to save a specific sheet as 
> a new workbook?
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>