Add certain naming convention

Hi,

I have some code to export a tab from my workbook and save it to the same location as the workbook from where the macro is run, along with the same name but it includes a date and time stamp. What need is to be able to add "CONS" to the start of the filename? I keep getting errors though?!?!?

Code below

Please Login or Register  to view this content.

Many thanks!!

I'm getting the run-time error '1004' with that code.