FolderSuffix Property

expression.FolderSuffix

expression    Required. An expression that returns one of the objects in the Applies To list.

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. You can use the UseDefaultFolderSuffix method to change the suffix to the language you are currently using in Microsoft Office.

By default, the name of the supporting folder is the name of the Web page 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 Web page). For example, suppose that you use the Dutch language version of Excel to save a file called "Page1" as a Web page. 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.

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