DefaultWebOptions.OrganizeInFolder property (Excel)
True if all supporting files, such as background textures and graphics, are organized in a separate folder when you save the specified document as a webpage. False if supporting files are saved in the same folder as the webpage. The default value is True. Read/write Boolean.
expression A variable that represents a DefaultWebOptions object.
The new folder is created in the folder where you saved the webpage, and is named after the document. If long file names are used, a suffix is added to the folder name. The FolderSuffix property returns the folder suffix for the language support that you have selected or installed, or the default folder suffix.
If you save a document that was previously saved with the OrganizeInFolder property set to a different value, Microsoft Excel automatically moves the supporting files into or out of the folder, as appropriate.
If you don't use long file names (that is, if the UseLongFileNames property is set to False), Excel automatically saves any supporting files in a separate folder. The files cannot be saved in the same folder as the webpage.
This example specifies that all supporting files are saved in the same folder when the document is saved as a webpage.
Application.DefaultWebOptions.OrganizeInFolder = False
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.