ActiveWorkbook.PublishObjects.Add( _ SourceType:= xlSourceRange, _ Filename:="\\Server2\Q1\stockreport.htm", _ Sheet:="First Quarter", _ Source:="D5:D9", _ HTMLType:=xlHTMLCalc). Publish
Dim objWrksht as Worksheet Dim objListobj as ListObject Dim strURL as String Set objWrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = objWrksht.ListObjects(1) strURL = objListObj.Publish(Array("HTTP://MyServer", "MyList", "Description of my list"), True)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question