Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 22nd 09, 01:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 1
Default How do I save a page in a workbook as a separate file?

I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

  #2   Report Post  
Old January 22nd 09, 01:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How do I save a page in a workbook as a separate file?

Save the many sheeted workbook with the new name
Now delete the unwanted sheets - right click each tab and use Delete
If you have lots of tabs: click the first one that is to go; hold SHIFT;
click the last one (do not include the required sheet); the right click and
delete
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"flowv" wrote in message
...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.



  #3   Report Post  
Old January 22nd 09, 01:58 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default How do I save a page in a workbook as a separate file?

Hi

Right click on the Sheet tab requiredMove or Copyclick CopySelect New
Workbook from the dropdown.
You will now be in a new workbook with that sheet included.
Save with whatever name you want

--
Regards
Roger Govier

"flowv" wrote in message
...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.


  #4   Report Post  
Old January 22nd 09, 02:31 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default How do I save a page in a workbook as a separate file?

Hi flowv

You can use this macro
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"flowv" wrote in message ...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.

  #5   Report Post  
Old January 22nd 09, 02:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default How do I save a page in a workbook as a separate file?

Oops, you only want to save one sheet I see now.
Forget my reply



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi flowv

You can use this macro
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"flowv" wrote in message ...
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.



Reply
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
Saving just 1 worksheet out of a workbook to a separate file Rich D Excel Discussion (Misc queries) 1 January 23rd 08 02:31 AM
How do I save part of a worksheet in a separate file? cleo Excel Worksheet Functions 3 May 15th 07 01:26 AM
Can I auto save to a separate file?(not the file I am working in) Jim Lynch Setting up and Configuration of Excel 1 August 14th 06 05:20 PM
Select sheet tabs in workbook & save to separate workbook files stratocaster Excel Worksheet Functions 2 March 1st 06 03:35 PM
How do I save sheets in a workbook to separate files? Omzala Excel Worksheet Functions 2 January 13th 05 06:23 PM


All times are GMT +1. The time now is 10:06 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017