| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split an Excel file into separate files
I'm seeing solutions regarding splitting an Excel file into separate
worksheets (FL0009), but is it possible to separate the file into completely separate files? I have a master file that needs to be split into separate files which will be password protected and emailed. One of the columns contains a name which is the criteria for splitting the file. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Split an Excel file into separate files
Hi kmrtx
See http://www.rondebruin.nl/copy6.htm For mailing and splitting you can also look at this example http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kmrtx" wrote in message ... I'm seeing solutions regarding splitting an Excel file into separate worksheets (FL0009), but is it possible to separate the file into completely separate files? I have a master file that needs to be split into separate files which will be password protected and emailed. One of the columns contains a name which is the criteria for splitting the file. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Split an Excel file into separate files
I saw this but not sure it is what I'm looking for as I don't have multiple
worksheets. I have one Workbook with one worksheet containing all the data. I need to split this into several workbooks (320)(with one worksheet) based on criteria within a column. Am I missing something? "Ron de Bruin" wrote: Hi kmrtx See http://www.rondebruin.nl/copy6.htm For mailing and splitting you can also look at this example http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kmrtx" wrote in message ... I'm seeing solutions regarding splitting an Excel file into separate worksheets (FL0009), but is it possible to separate the file into completely separate files? I have a master file that needs to be split into separate files which will be password protected and emailed. One of the columns contains a name which is the criteria for splitting the file. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Split an Excel file into separate files
Sorry I not read it good
See this example http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kmrtx" wrote in message ... I saw this but not sure it is what I'm looking for as I don't have multiple worksheets. I have one Workbook with one worksheet containing all the data. I need to split this into several workbooks (320)(with one worksheet) based on criteria within a column. Am I missing something? "Ron de Bruin" wrote: Hi kmrtx See http://www.rondebruin.nl/copy6.htm For mailing and splitting you can also look at this example http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kmrtx" wrote in message ... I'm seeing solutions regarding splitting an Excel file into separate worksheets (FL0009), but is it possible to separate the file into completely separate files? I have a master file that needs to be split into separate files which will be password protected and emailed. One of the columns contains a name which is the criteria for splitting the file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to split a large excel file into multiple smaller exel files. | Excel Discussion (Misc queries) | |||
| Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
| Macro to split excel file into seperate files and then email | Excel Discussion (Misc queries) | |||
| Saving each row of an excel file in separate excel files | Excel Programming | |||
| Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) | |||
Linear Mode
