Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin
 
Posts: n/a
Default Saving worksheets within workbooks as individual files

I send you a private mail


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Colin Hayes" wrote in message ...
In article , Ron de Bruin writes
Hi

With code you can do this
http://www.rondebruin.nl/copy6.htm


Hi Ron

OK I tried this. I pasted the code from your page into my macro and hoped it would take each of the 50 sheets in turn and save
them out as individual xls files. They're just numbered 1-50.

Unfortunately , it only saved three files , all of them empty! I'm doing something wrong , clearly. I'll try again.



Best Wishes


Colin



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
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 01:32 AM.

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

About Us

"It's about Microsoft Excel"