Button - Save Location
 

Hi guys

I have a file which is a template. This file is read only, and is an Excel
sheet

What I want to do, is place a button on the sheet.

When the button is pressed, a box appears asking for todays day in format:
DD.MM.YYYY (Ideally, if it could automatically set the date, this would be a
bonus.... )

The locationg I want the button to save is: c:/documents/files

How can I do this?