Error 1004 when trying to save file with name generated from cell value

I wrote a workbook that automatically generated a weekly report from Access data, created a new workbook with just the report then saved the new workbook with a name generated from text and a cell value (the date).

This worked fine in Excel 2007, now the charity I help has upgraded to Office 2013 and the macro now generates a 1004 error
"Microsoft Excel cannot access the file
'C:\Dellsys\WeeklyReports\BECCD000' "

The BECCD000 changes each time I try to run the macro, but FName2 is still picking up the correct cell value, see the code below.

Please Login or Register  to view this content.

Anyone aware of any 2013 problems that will cause this?

Put this at the start of code and then See. Maybe It works.

Please Login or Register  to view this content.

Terios1951,

Welcome to the board.

Unfortunately:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Originally Posted by Terios1951

Ooops sorry about that. Will know in future.

Why don't your fix it anyway. It's a 20 second fix. Click edit on your first post, highlight the code, click the # and save the post again.