Edit

Share via

WebOptions.UseDefaultFolderSuffix method (Excel)

  • Article

Sets the folder suffix for the specified document to the default suffix for the language support that you have selected or installed.

Syntax

expression.UseDefaultFolderSuffix

expression A variable that represents a WebOptions object.

Remarks

Microsoft Excel uses the folder suffix 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).

The suffix appears in the folder name after the document name. For example, if the document is called Book1 and the language is English, the folder name is Book1_files. The available folder suffixes are listed in the FolderSuffix property topic.

Example

This example sets the folder suffix for the first workbook to the default suffix.

Workbooks(1).WebOptions.UseDefaultFolderSuffix

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.