Heenan, Lambert
Lambert.Heenan at AIG.com
Thu Jul 19 10:35:13 CDT 2007
Even easier: Right Click the tab and select "Move Or Copy". In the Move or Copy dialog select "(new book)" in "To Book" combo and check the "Create a Copy" box at the bottom. That gives you an exact copy of the sheet in a new book. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, July 19, 2007 11:02 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT: Excel - Get sheet out of workbook Bueno. Silly me, I expect something like "select the sheet tab, right click, save as..." Makes too much sense I guess. Thanks, John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Thursday, July 19, 2007 10:54 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT: Excel - Get sheet out of workbook Yes - 1) Go to Sheet X of Y. 2) Select the entire sheet by clicking the gray box at the intersection of columns and rows. 3) Copy 4) Open new workbook by clicking the New button. 5) Select the same gray box as in 2). 6) Paste 7) Repeat as needed. This will preserve the text formatting and column and row sizes. HTH! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, July 19, 2007 9: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com