auto plug in cell as save as (multi)

[DPPHAM]

I have a workbook that has 3 sheets. On sheet 2 (A9) value to be plugin automatically as the file name, when I want to save as.
file save as format: A9(customers name) A10(date) A11(repair done)

I am very new to this. thank you

[nemo74]

To do this you are going to have to use VBA. Also in order for it to work correctly the dates will have to formatted as text and the proper save methods for excel. For example no "/" in your date which is going to be text. This could make problems for other things in your sheet. Also you will need a helper cell to concat the cells you need.

Hopefully since I'm still semi new at this someone can come in school us both and get the job done nice and easy, but until then use this:

Please Login or Register  to view this content.

[DPPHAM]

To do this you are going to have to use VBA. Also in order for it to work correctly the dates will have to formatted as text and the proper save methods for excel. For example no "/" in your date which is going to be text. This could make problems for other things in your sheet. Also you will need a helper cell to concat the cells you need.

Hopefully since I'm still semi new at this someone can come in school us both and get the job done nice and easy, but until then use this:

Please Login or Register  to view this content.

I am not able to reply

[DPPHAM]

To do this you are going to have to use VBA. Also in order for it to work correctly the dates will have to formatted as text and the proper save methods for excel. For example no "/" in your date which is going to be text. This could make problems for other things in your sheet. Also you will need a helper cell to concat the cells you need.

Hopefully since I'm still semi new at this someone can come in school us both and get the job done nice and easy, but until then use this:

Please Login or Register  to view this content.

ok I found out why I couldn't reply. thank you nemo for that. I found this code

Please Login or Register  to view this content.

two problems with this code. I changed the format extension from ".xls" to ".xlsx" because im using 2010 excel. I get a errors.
problem two, can I have a pop up menu when I press on the command button, instead of auto saving.

[nemo74]

You will stil need to change the date since you can't save "/" in excel filenames, I'm also not sure what you wanted in a pop up, or when you wanted it since you were not clear. So here, you have a button and pop up to confirm:

Please Login or Register  to view this content.

[nemo74]

Did this work for you?

[RonBallard]

Nemo, I'm new to the forum and recently ran into the same issue, but using data from 4 different cells in the naming nomenclature. I wanted you to kow that I found this extremely useful. Once I modified it to the 4 strings and identified the correct cells and path to save, it worked like a charm! Thank you very much for your expertise!