workbooks("C:\Suivi_DLC\Archives_" & Range("C33").Value & "\Batch_BL_N°" & Range("B27").Value & "\Docsuivicharge.mht").activate activeworkbook.save
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub mht() ' ' mht Macro ' sauvegarde mhtml ' ' Workbooks.Open "C:\Suivi_DLC\Archives_" & Range("C33").Value & "\Batch_BL_N°" & Range("B27").Value & "\Docsuivicharge.xls" Range("A1:Z41").Select With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _ "C:\Suivi_DLC\Archives_" & Range("A60").Value & "\Batch_BL_N°" & Range("A61").Value & "\Docsuivicharge.mht", "Feuil1", "$A$1:$Z$41", xlHtmlStatic, _ "Docsuivicharge_22789", "") .Publish (True) .AutoRepublish = False End With ActiveWorkbook.Close True End Sub