| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Looking forward to the solution. Enjoy the coffee.
"Ron de Bruin" wrote: Hi Chaplain Doug I will make a example for you today (1-2 hours) First I take a cup of coffee with my wife and children. -- Regards Ron de Bruin http://www.rondebruin.nl "Chaplain Doug" wrote in message ... Dear Ron: Beautiful! Just what I needed. Now another question: I would love to produce a module that would bring up a dialog that would allow the user to browse to a file of his choice, specify a destination of his choice, and then run this code on the workbook so specified and save the individual files in the location specified. How could I creeate such a module such that it is independent of a particular worksheet? (I placed your code in the worksheet I am currently working on, but would like the code to be standalone for this more generic application). Thanks for any suggestions, and God bless. Chaplain Doug "Ron de Bruin" wrote: Hi Try this one that save the files in "C:\" with the sheet name Sub test() Dim a As Integer Dim wb As Workbook Application.ScreenUpdating = False For a = 1 To ThisWorkbook.Worksheets.Count ThisWorkbook.Sheets(a).Copy Set wb = ActiveWorkbook wb.SaveAs "C:\" & wb.Sheets(1).Name & ".xls" wb.Close False Set wb = Nothing Next a Application.ScreenUpdating = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Chaplain Doug" wrote in message ... Excel 2003. I have multiple tabs (sheets?) in my workbook. I would like to create an individual file for each sheet. How may I do this? I need to do this regularly, so an automated procedure (versus manually cutting and pasting) would be greatly appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
| How to open 123 files with excel | Excel Discussion (Misc queries) | |||
| Why does Excel saves all my files as temporary files? | Excel Discussion (Misc queries) | |||
| Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
| Why does Excel in XP create new files? | Excel Discussion (Misc queries) | |||
Threaded Mode
