LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes
 
Posts: n/a
Default Saving worksheets within workbooks as individual files


HI all

I have a small problem I can't solve:

I have a workbook of 50 worksheets. Each worksheet in the workbook has
different data. I want to save each individual worksheet out as a
stand-alone xls file.

When I go to save each of the worksheets , I find that excel saves the
whole work book.

How can I save the contents of individual worksheets as discrete files ,
containing just the data in the individual worksheet?

Grateful for any help.



Best Wishes


Colin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many workbooks and worksheets can Excel understand? Mike Excel Discussion (Misc queries) 1 February 10th 06 01:58 PM
Saving an Excel document after moving additional worksheets to it SteveD62226 New Users to Excel 0 November 21st 05 06:56 PM
Convert excel worksheets into new workbooks (new files) G Setting up and Configuration of Excel 2 November 17th 05 03:19 PM
Linking set of worksheets between different workbooks! gp Excel Discussion (Misc queries) 0 March 22nd 05 09:27 PM
Converting worksheets to workbooks. Is there an easy way? Jim Excel Discussion (Misc queries) 1 March 22nd 05 02:31 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"