Hi,

I want add come code to the end of a macro that will allow a user to select a date and then the macro will take that date and add it to the end of a filename and then save the file in a certain location.

E.g. save the file as "Report for X" where X is the date the user has selected once prompt.

What is the best way to do this?

TLP