WebPagePreview Method
Displays a preview of the specified workbook as it would look if saved as a Web page.
expression.WebPagePreview
expression An expression that returns a Workbook object.
Example
This example displays a preview of the first workbook as a Web page.
Workbooks(1).WebPagePreview