Saving file with "." in filename

[tiredofit]

My workbook is called abc.xlsm

I run the following code and it's fine, ie it saves it as abc.xlsm

ThisWorkbook.SaveAs Filename:=Left(String:=ThisWorkbook.FullName, _
                                                       Length:=Len(ThisWorkbook.FullName) - 5)

If I now save my workbook, close it, change its name in Windows Explorer to abc 1.2.xlsm, then open and run the above code, the file is no longer saved as an Excel file,

ie in Windows Explorer, I see a file called abc 1.2 (without the .xlsm extension), so it doesn't know it's an Excel file, meaning double clicking doesn't automatically open it.

I suspect the reason for this odd behaviour is that abc 1.2.xlsm contains a "." in the filename.

Why does VBA behave in this way and going forwards, is it NOT a good idea to save filenames with a "."?

Thanks

 

[RoryA]

It's a better idea to specify the FileFormat parameter in all SaveAs operations, otherwise you may run into many unexpected problems.

 

[tiredofit]

It's a better idea to specify the FileFormat parameter in all SaveAs operations, otherwise you may run into many unexpected problems.

Thanks but adding this didn't help:

FileFormat:=52

it still saved it without the file extension.

 

[RoryA]

Why aren't you including the extension in the file name when you save it?

 

[tiredofit]

Why aren't you including the extension in the file name when you save it?

If the filename was already .xlsm, this code saved it as .xlsm as well , provided the filename DIDN'T have a "." in it.

ThisWorkbook.SaveAs Filename:=Left(String:=ThisWorkbook.FullName, _
                                                       Length:=Len(ThisWorkbook.FullName) - 5)

ie if the filename was myfile.xlsm, then the above code saved it as myfile.xlsm.

However, if the filename was myfile_v1.1.xlsm, using the above code didn't automatically add the .xlsm. It saves it as myfile_v1.1

 

[RoryA]

That doesn't really explain why you aren't including the extension in the file name when you save it.

 

[tiredofit]

Because when I first did it, it automatically included it, so I didn't think you had to.

 

[Stiuart_W]

Also. I would say it's really not a good idea to have additional "." in the file name in addition to the separator before the file extension

 

[tiredofit]

Also. I would say it's really not a good idea to have additional "." in the file name in addition to the separator before the file extension

I agree but my users insist!