[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