Advertisement
Guest User

Untitled

a guest
Aug 26th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. ObjectToPaste = xlApp.Range(UserformObj.listCharts.SelectedItem).Address
  2. Title = UserformObj.listCharts.SelectedItem.SubItems(4)
  3. Caption = IIf(KUKUKU3 = 1, Title, "")
  4. On Error Resume Next
  5. With oWB.PublishObjects.Add(xlSourceRange, Where, sht, _
  6. ObjectToPaste, xlHtmlStatic, "", Caption)
  7. .Publish (False)
  8. .AutoRepublish = UpdateHTml
  9. End With
  10. On Error GoTo 0
  11.  
  12. With ActiveWorkbook.PublishObjects.Add(SourceType:=xlSourceRange, _
  13. Filename:="\Serverstockreport.htm", Sheet:="First Quarter", Source:="$G$3:$H$6", _
  14. HtmlType:=xlHtmlStatic, DivID:="Book1_4170")
  15. .Publish (True)
  16. .AutoRepublish = False
  17. End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement