'articles pour commencer, mais attention je ne sais pas s'ils existent tjrs chez microsoft
http://support.microsoft.com/support/kb/articles/q168/5/61.asp
http://www.microsoft.com/exceldev/articles/ch11.htm
http://jacxl.free.fr/cours_xl/accueil.html
pour xl2000 (et pt être xl97)
Un exemple d'utilisation par code de l'assistant de conversion HTML d'Office
Sub SaveAsHtml()
'this saves as html
Dim ObjectToConvert 'As Variant
Dim Reslult As Integer
Set ObjToConvert = Sheets("sheet5").Range("b1:r14")
AddIns("Internet Assistant Wizard").Installed = True
Result = htmlconvert(rangeandcharttoconvert:=Sheets("sheet5").Range("b1:r143"), useexistingfile:=False, usefrontpageforexistingfile:=False, addtofrontpageweb:=False, codepage:=1252, htmlfilepath:="c:\My Documents\wssnba.htm", linebeforetablefullpage:=True, namefullpage:="VolFreak")
Application.Save : ActiveWindow.Close
'this publishes to ftp,but not as html (I have tried File format html)
Workbooks.Open FileName:="C:\My Documents\wssnba.htm"
Windows("wssnba.htm").Activate
ActiveWorkbook.SaveAs FileName:="ftp://ftp.xoom.com/wssnba.prn", FileFormat :=xlTextPrinter, CreateBackup:=False
End Sub
bye
stephane
