WebOptions.FolderSuffix property (Excel)
Returns the folder suffix that Microsoft Excel uses when you save a document as a webpage, use long file names, and choose to save supporting files in a separate folder (that is, if the UseLongFileNames and OrganizeInFolder properties are set to True). Read-only String.
Syntax
expression.FolderSuffix
expression A variable that represents a WebOptions object.
Remarks
Newly created documents use the suffix returned by the FolderSuffix property of the DefaultWebOptions object. The value of the FolderSuffix property of the WebOptions object may differ from that of the DefaultWebOptions object if the document was previously edited in a different language version of Microsoft Excel. Use the UseDefaultFolderSuffix method to change the suffix to the language that you are currently using in Microsoft Office.
By default, the name of the supporting folder is the name of the webpage plus an underscore (_), a period (.), or a hyphen (-) and the word "files" (appearing in the language of the version of Excel in which the file was saved as a webpage). For example, suppose that you use the Dutch language version of Excel to save a file called Page1 as a webpage. The default name of the supporting folder is Page1_bestanden.
The following table lists each language version of Office, and gives its corresponding LanguageID property value and folder suffix. For the languages that are not listed in the table, the suffix .files is used.
| Language | LanguageID | Folder suffix |
|---|---|---|
| Arabic | 1025 | .files |
| Basque (Basque) | 1069 | _fitxategiak |
| Portuguese (Brazil) | 1046 | _arquivos |
| Bulgarian | 1026 | .files |
| Catalan | 1027 | _fitxers |
| Chinese - Simplified | 2052 | .files |
| Chinese - Traditional | 1028 | .files |
| Croatian | 1050 | _datoteke |
| Czech | 1029 | _soubory |
| Danish | 1030 | -filer |
| Dutch | 1043 | _bestanden |
| English | 1033 | _files |
| Estonian | 1061 | _failid |
| Finnish | 1035 | _tiedostot |
| French | 1036 | _fichiers |
| German | 1031 | -Dateien |
| Greek | 1032 | .files |
| Hebrew | 1037 | .files |
| Hungarian | 1038 | _elemei |
| Italian | 1040 | -file |
| Japanese | 1041 | .files |
| Korean | 1042 | .files |
| Latvian | 1062 | _fails |
| Lithuanian | 1063 | _bylos |
| Norwegian | 1044 | -filer |
| Polish | 1045 | _pliki |
| Portuguese | 2070 | _ficheiros |
| Romanian | 1048 | .files |
| Russian | 1049 | .files |
| Serbian (Cyrillic) | 3098 | .files |
| Serbian (Latin) | 2074 | _fajlovi |
| Slovakian | 1051 | .files |
| Slovenian | 1060 | _datoteke |
| Spanish | 3082 | _archivos |
| Swedish | 1053 | -filer |
| Thai | 1054 | .files |
| Turkish | 1055 | _dosyalar |
| Ukrainian | 1058 | .files |
| Vietnamese | 1066 | .files |
Example
This example returns the folder suffix used by the first workbook. The suffix is returned in the string variable strFolderSuffix.
strFolderSuffix = Workbooks(1).WebOptions.FolderSuffix
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.