Name
publishobjects
.Add(SourceType
, Filename
, [Sheet
], [Source
], [HtmlType
], [DivID
], [Title
])
Synopsis
Creates an object that can be published from the workbook as a web page.
Argument |
Settings |
---|---|
|
An xlSourceAutoFilter xlSourceChart xlSourcePivotTable xlSourcePrintArea xlSourceQuery xlSourceRange xlSourceSheet xlSourceWorkbook |
|
The full URL of the web page to create. |
|
If |
|
If |
|
An xlHtmlCalc (interactive range) xlHtmlChart (interactive chart) xlHtmlList (interactive list) xlHtmlStatic (noninteractive) |
|
The |
|
A title to include in the |
The arguments used by Add
are complicated and their meanings vary based on the published source and target. It is easiest ...
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.