clipro
Board Regular
- Joined
- Jan 12, 2005
- Messages
- 195
Hi
I need some help and I'll be very grateful if somebody can give me the answer. I am not very optimistic because i've already ask few programmers that can not help me.
the problem:
I have one xls file. in one cell (par example A1) of the file using the CONCATENATE formula i have a string/text/. It is necessary the file to be saven each time under different name. the name of the new file is the text in the cell above.
I want to create a macro that must to:
1. create a copy of the original fine (to save the existing file under new name)
2. to save the copy under the name that is into the cell A1
why it is necessary: my file will be used by more that 100 people. each of them will have a copy of the original file and will full some data into it. After that each user will send to me an e-mail with the new file. if I receive emails with one and the same name there will be a big danger of mistakes
p.s. i know how to create a macro wich to save the file under one and the same name each time but it is unusefill for me
second p.s. the problem have an easy answer "let the users to save as the copy of the file under different name" - it is not a good decision because the name includes more than 35 chifres so the mistakes will be really big and i use the names of the files in another program
i hope that some of you can help me
... please ray:
I need some help and I'll be very grateful if somebody can give me the answer. I am not very optimistic because i've already ask few programmers that can not help me.
the problem:
I have one xls file. in one cell (par example A1) of the file using the CONCATENATE formula i have a string/text/. It is necessary the file to be saven each time under different name. the name of the new file is the text in the cell above.
I want to create a macro that must to:
1. create a copy of the original fine (to save the existing file under new name)
2. to save the copy under the name that is into the cell A1
why it is necessary: my file will be used by more that 100 people. each of them will have a copy of the original file and will full some data into it. After that each user will send to me an e-mail with the new file. if I receive emails with one and the same name there will be a big danger of mistakes
p.s. i know how to create a macro wich to save the file under one and the same name each time but it is unusefill for me
second p.s. the problem have an easy answer "let the users to save as the copy of the file under different name" - it is not a good decision because the name includes more than 35 chifres so the mistakes will be really big and i use the names of the files in another program
i hope that some of you can help me
... please ray: