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

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



More information about the AccessD mailing list