need help: to save file.xls under new name each time

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 :pray:
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi clipro, Welcome to the board.
This doesn't sound too hard, depending on a thing or two.
Getting it to save under the name of what's in a cell (No. 2 in your post) is easy. (ie.)
Code:
ActiveWorkbook.SaveAs Filename:= _
        "C:\My Documents\" & Sheets("Sheet1").[A1].Text & ".xls"
(Amend to your own path...)
I'm not sure what you mean in No. 1 in your post.
(And I have no idea what "chifres" means...)

Dan
 
Upvote 0

Forum statistics

Threads
1,223,195
Messages
6,170,660
Members
452,344
Latest member
LarryRSch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top