다음을 통해 공유

WebOptions Object (Excel)

  • 아티클

Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.

Remarks

You can return or set attributes either at the application (global) level or at the workbook level. (Note that attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.) Workbook-level attribute settings override application-level attribute settings. Application-level attributes are contained in the DefaultWebOptions object.

Example

Use the WebOptions property to return the WebOptions object. The following example checks to see whether PNG (Portable Network Graphics) is allowed as an image format and then sets the strImageFileType variable accordingly.

Set objAppWebOptions = Workbooks(1).WebOptions 
With objAppWebOptions 
 If .AllowPNG = True Then 
 strImageFileType = "PNG" 
 Else 
 strImageFileType = "JPG" 
 End If 
End With

참고 항목

개념

WebOptions Object Members

Excel Object Model Reference