vba, how to zip file with special characters?
compression, excel, vba, zip
Solution
It's already a standard feature in MacOS, but in Windows 10 you need to to the following:
Type "region" in the Start Menu search box
Open the Region and Language Control Panel
Click the Administrative tab on the top
In "Language for non-Unicode programes" section, click "Change system locale...".
Check "Beta: Use Unicode UTF-8 for worldwise language support."
Restart Windows and try again.
Problem
When zipping all files in a folder i get an error ``` '''''Create empty Zip File NewZip (FileNameZip) Set oApp = CreateObject("Shell.Application") '''''Copy the files to the compressed folder oApp.Namespace(FileNameZip).CopyHere oApp.Namespace(FolderName).items ''error here ``` Error: c:...\Jørgen.doc cannot be compressed because it includes characters that cannot be in a compressed folder, such as ø. You should rename this file or directory. However if i navigate to the file and manually copy it to the zip folder it works no problem. Is there a way to get round this error in my vba code