| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save several copies of the same worksheet
hi.
I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Hi ayeshasid
I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Hi
It's a clientlist, so i have to name them by each clients name, to make changes on them later, but they all have to look the same way from the beginning.... Ron de Bruin skrev: Hi ayeshasid I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Do you have a list of client names in Excel ?
We can use this list to name the workbooks then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Hi It's a clientlist, so i have to name them by each clients name, to make changes on them later, but they all have to look the same way from the beginning.... Ron de Bruin skrev: Hi ayeshasid I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Yes, i do have the client list in excel
how do i proside to do this then? Ron de Bruin skrev: Do you have a list of client names in Excel ? We can use this list to name the workbooks then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Hi It's a clientlist, so i have to name them by each clients name, to make changes on them later, but they all have to look the same way from the beginning.... Ron de Bruin skrev: Hi ayeshasid I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Try this macro with the names in column A on the activesheet
Change this path "C:\Users\Ron\test\" Sub test() Dim cell As Range Application.ScreenUpdating = False For Each cell In Columns("A").SpecialCells(xlCellTypeConstants) ThisWorkbook.SaveCopyAs "C:\Users\Ron\test\" & cell.Value & ".xls" Next cell Application.ScreenUpdating = True End Sub Copy the macro in a normal module Alt F11 Insert module Paste it in the module Alt q to go back to Excel You can run the macro with Alt-F8 select the macro and press Run -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Yes, i do have the client list in excel how do i proside to do this then? Ron de Bruin skrev: Do you have a list of client names in Excel ? We can use this list to name the workbooks then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Hi It's a clientlist, so i have to name them by each clients name, to make changes on them later, but they all have to look the same way from the beginning.... Ron de Bruin skrev: Hi ayeshasid I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Save several copies of the same worksheet
Another way is to use Filecopy
http://www.rondebruin.nl/folder.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Try this macro with the names in column A on the activesheet Change this path "C:\Users\Ron\test\" Sub test() Dim cell As Range Application.ScreenUpdating = False For Each cell In Columns("A").SpecialCells(xlCellTypeConstants) ThisWorkbook.SaveCopyAs "C:\Users\Ron\test\" & cell.Value & ".xls" Next cell Application.ScreenUpdating = True End Sub Copy the macro in a normal module Alt F11 Insert module Paste it in the module Alt q to go back to Excel You can run the macro with Alt-F8 select the macro and press Run -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Yes, i do have the client list in excel how do i proside to do this then? Ron de Bruin skrev: Do you have a list of client names in Excel ? We can use this list to name the workbooks then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... Hi It's a clientlist, so i have to name them by each clients name, to make changes on them later, but they all have to look the same way from the beginning.... Ron de Bruin skrev: Hi ayeshasid I have to save 400 copies of the same Worksheet or workbook ? How do you want to name them ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ayeshasid" wrote in message ... hi. I have to save 400 copies of the same worksheet in different names. Any idea's of how i can do this as easy as possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create 50 copies of a worksheet in the same file | Excel Worksheet Functions | |||
| How can I Make 3 copies of one worksheet Page? | Excel Worksheet Functions | |||
| Multiple copies of a template worksheet in one file | Excel Discussion (Misc queries) | |||
| printing multiple copies of a worksheet | Excel Discussion (Misc queries) | |||
| Why does an excel worksheet default to 24 copies when printing | Excel Worksheet Functions | |||
Linear Mode
