|
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? |
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com