Enabling "Beta: User unicode UTF-8" corrupts file and removes saved vba

[SunValley]

I was trying to rename a file with VBA, but when I put the "/" character in the name, things don't work. Then I read that I should enable "Beta: User unicode UTF-8" so that it could support the character. However, when enabling and restarting the computer, Excel says it has corrupted the file, the worksheet is saved but all VBA codes are removed. I have a backup of the file but every time I try to open it I am asked to recover and then the VBA is removed.

 

[GlennUK]

Can I ask why you want to put such a character in a filename? There are a whole bunch of characters that should not be used in filenames ... so why attempt to do that kind of thing?

 

[SunValley]

Can I ask why you want to put such a character in a filename? There are a whole bunch of characters that should not be used in filenames ... so why attempt to do that kind of thing?

I sometimes use "/" to shorten names by missing some words.
When you say that some characters should not be used for filenames, do you mean only for VBA Excel, or may Windows have problems with these characters?

 

[GlennUK]

I sometimes use "/" to shorten names by missing some words.
When you say that some characters should not be used for filenames, do you mean only for VBA Excel, or may Windows have problems with these characters?

Yes, Windows will have problems. Use underscore instead of "/".