Auto-save a new file with data from 3 cells

[Glio]

I would like to have a template .xlt file which, when three cells have been completed (and they must be completed!) automatically saves the .xls file in the one folder with the file name made up of the concatenated cells data.

This is in part linked to this 'Prevent Save unless cells are complete' thread
http://www.excelforum.com/showthread.php?t=625297

This would then ensure that my users would always get the file naming protocol correct!

The three cells have been named as ExIncOp, Name and StartDate. StartDate has been formatted to appear as dd-mmm-yy.

I have put the formula

Please Login or Register  to view this content.

in one cell which produces what I want except that the date is no longer formatted dd-mmm-yy and then recorded a macro to save the file

Please Login or Register  to view this content.

which unfortunately did not allow me to paste what I had copied from the concatenated cell into the file name field.

Is this possible?

[VBA Noob]

Try changing name ranges to e.g

Please Login or Register  to view this content.

VBA Noob

[Glio]

VB Noob

Thanks for your response. I have tried Ranges as you suggested

Please Login or Register  to view this content.

but it now gives me a 400 warning box, which I think means the form is already in use

[VBA Noob]

Forgot the format .xls also you can't use / when naming workbooks
try something like

Please Login or Register  to view this content.

Change path to your path

VBA Noob

[Glio]

Thanks a lot VB Noob,

You pointed me to my final effort, which works exactly as I wanted i.e.

Please Login or Register  to view this content.

Thanks again

[VBA Noob]

Your welcome

VBA Noob