title: Vba PublishObjects- How resize to in html?
body: <p>The following code publish a range from Excel to an HTML file. Is there a way to make the published range to be of different size than the default one? Alternatively how could I publish an Image version to the range to the same file?</p>
  
  <pre><code>ObjectToPaste = xlApp.Range(UserformObj.listCharts.SelectedItem).Address
              Title = UserformObj.listCharts.SelectedItem.SubItems(4)
              Caption = IIf(KUKUKU3 = 1, Title, "")
              On Error Resume Next
              With oWB.PublishObjects.Add(xlSourceRange, Where, sht, _
                                          ObjectToPaste, xlHtmlStatic, "", Caption)
                  .Publish (False)
                  .AutoRepublish = UpdateHTml
              End With
              On Error GoTo 0
  </code></pre>