Save worksheets as csv files in a given directory

I have three worksheets (called 'Events', 'Markets', 'Selections') that I want to save columns A:L as a csv file in a specified directory.

I want to do this through some vba code to put in a button on a worksheet.

The file name of the csv file wants to be " 'User defined description'_&'Worksheet Name' &'current date/time'...

i.e. UserDescription_Events_28-06-2011_15:26:33.csv

The beginning of the code wants a message box to appear for the user to enter the 'User Description'.

Thank you in advance.

Thanks for this Dom. I have amended it a little to suit my needs but it works great.

I would also like to add to this code now by also saving the workbook to a different directory with the same filename and this time as .xls file.

Please Login or Register  to view this content.

I tried to add the bit beneath ''SAVE WORKBOOK IN SPECIFIED FOLDER" but was getting errors when I tried to run the code. Can someone tell me what schoolboy error I am making?

Thanks,
Adam.