VBA - Publishing html reports on Sharepoint (check in / check out)

[seeyah]

Hello,

I have been struggling for the past two days on the following problem :
I would like to publish a series of reports as .html files (web pages) on a sharepoint site with VBA, without having to worry whether I have to check in or check out the uploaded files.

Result :
The html publication is working fine, the problem is that the following code let the published files checked out on sharepoint, hence If i don't manually check in all the files (even the different graphs in the relevant folder), other users cannot see the different reports.

With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _        "https://...../report.htm" _
        , "Reporting", "", xlHtmlStatic, _
        "HP QC", "Reporting")
        .Publish (True)
        .AutoRepublish = False
    End With

I know how to check in / check out a workbook, however the checkin method doesn't seem to work with html reports. My questions :
- Is there a solution to check in / check out html files (and generated misc files) with VBA ?
- Alternatively, if the check in / check out mechanism cannot be implemented, would it be at least possible from excel to publish and check in these html reports, but whenever I have to update them I juste delete with VBA the different files and upload them again ?

Finally there are two requirements, these reports have to be in .html (Web Page) as they are then used by another application hence I cannot use the Single File Web Page for exemple, also they should always have the same name.

Any solution would be more than welcome

Many thanks