Setting a filename in Excel

[dzshanno]

Is there a way that I can force the filename for a workbook?

I want a user to open a template file. Fill in some details and save the file with its filname being based on a cell on the sheet

I could use

projectfilename = sheets("PEROJECT INFO&quot.CELLS(5,5).value
saveas (projectfilename,xlnormal)

but where should I put it to ensure that it is fired correctly?

If I put it in beforeSave I get an infinite loop. If I set cancel = true It doesnt seem to save at all

any ideas?

Thanks in advance

David

 

[ETID]

remove the save and save as commands from your tool bar, then.

Put your code in the "on workbook close sub".