Hi there. Apologies for thread bump but back at work and still struggling with same problem!

I am looking for some macro code to create an Input box in excel which will prompt the user to enter a specific date (not todays date so NOW function is not appropriate). This will in turn cause the file to be saved in a specific folder with the date becoming the name of the saved file.

Any suggestions would be greatly appreciated

Cheers