Auto naming adds extra characters after file type rather than before

I have the following code:

Please Login or Register  to view this content.

it adds the text "ABC_" to the beginning of the name of the workbook I am getting ready to save. For organizational purposes, I decided it would be best to have the extra characters added after the name rather than before (ie Test_ABC.csv rather than ABC_Test.csv). I changed the code to the following:

Please Login or Register  to view this content.

However, this sets the name as Test.csv_ABC Is there any way to have the extra characters fall between the name and the file type?

In different instances I'm told that my code will work fine so I'm attaching the actual spreadsheet that I am using so that you can see how it's happening in my specific instance. The only thing you have to do is open up the attachment Test.xlsx and save it as a .csv (this site wont let me upload it as a .csv since it's technically not one). Then open up ABC_Tool.xlsx and it will automatically run the macro. Use the macro to open up the Test.csv you saved and you'll see what I am talking about.

Thanks. Any help would be greatly appreciated.

Maybe something like:

Please Login or Register  to view this content.

Regards