Application.GetSaveAsFilename not populating derived filename

[MattyG1406]

Hi, I wonder if someone can help.

I am trying to get a piece of code save the current workbook as a derived filename, but the filename does not populate in the "File/Save As" window when i run the process. The filename displays in the msgbox just as I want it to. I've copied below an extract from the process. Can anyone help?

Please Login or Register  to view this content.

[Bishonen]

same logic works for me allright:

Please Login or Register  to view this content.

Do you have write rights in the location(seeing "T:/" as the drive)? Does the file save at all but under a different name ?

[MattyG1406]

Yes I do have write rights. The process continues and completes if I then add a filename manually into the File/Save As window.

[Bishonen]

nvm. I think I got it all wrong.

I guess your filename has some invalid characters or is too long (255 chars+)? What if you enter something simple as filename first:

Please Login or Register  to view this content.

If that works, then you know you have to work on the filename expression

Here's what google says about the limitations (might not be all though):
Reserved Characters and Names

Most common characters can be used in naming files. However, the following characters are reserved and cannot be used in a file name:
< > : " / \ | ? *
Also, neither a space nor a period can be used at the end of a name. Further, files cannot have the following reserved device names: CON, PRN, AUX, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, and LPT9. Note that the case does not matter in Windows.

[MattyG1406]

"Test Workbook" worked fine.

It does appear to be the character limit of 255 (I'm assuming this is the filepath and filename combined) as when I manually enter the filename I want and hit Save, the last 2 characters are cut off in the filename box, but yet the file is visible afterwards with the full name.

I will experiment further by reducing the length of one of the folders that is part of the filepath.

[MattyG1406]

All sorted . . . It was the "." within "v3.0" at the end of the filename. I've replaced it with a "-" and all is working perfectly! Thanks for the guidance!