Save file based on cell value on a specific sheet

[tan3157]

Hi,

I have the below code to save the file in a specific location based on a cell name. The cell name is concatenated based on today's date, the files name, this month and then the time created.

However, whenever I run the macro to save, the below section comes up as an run time error 1004.

Please Login or Register  to view this content.

The naming convention of the file will be the below once concatenated. The cell is still a formula once the save as code is run.

2017-05-30 Issue Tracker May 11:14:23

Does anyone know how to resolve the error please or any other code to help make it run smoother.

Please Login or Register  to view this content.

Thanks

[Special-K]

FPpath's last character is \
But you are combining ANOTHER \ in the "ThisWorkBook" variable so you're ending up with

\\Homeshare\HOME0027\G019\My Documents\\ & FName

The first \\ is fine if you are saving the file to a server but the second pair doesn't look at all right to me.

Change this:

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[tan3157]

Hi,

Thanks for this. However, still get the "Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed, on the same section

Am I still doing something wrong.

Thanks

[JOHN H. DAVIS]

I would also add:

Please Login or Register  to view this content.

Or which ever extension you intend.

[tan3157]

Hi

Sorry this unfortunately also does not work. It has only stopped working today, since I added the time to the end of the concatenate formula.

Thanks

[Special-K]

1. Change the name of the sub to something else, SaveAs is probably a reserved word.

2. Change your pathname to something local like C:\
Run the program again.
If it works and saves to the C drive then you dont have access to the server youre trying to save to.

[Special-K]

Times as text will include colons.
You can't have colons as part of a filename.
Replace them with hyphens or omit them altogether.

[tan3157]

Hi

Thanks that was the reason. Now all resolver. Thanks again for your help