I am an excel newbie creating a form in Excel.

In cell A1 I have a formula that concatenates the date in numerical format with another cell on the form.

I have a button on the form that I want to link to a macro that will automatically "save as" and change the file name to the result of the formula in cell A1.

I have searched the forum and read several posts but have not yet found the answer.

Anyone?