>I need to write a routine that will permit VFP to tell Excel to save a spreadsheet as HTML.
>
>I tried using the macro recorder, but it was no use because Excel used a wizard to do the SAVEASHTML and the macro contained no code. However, I am using an old version of Excel (Office/97).
>
>Is there a way to automate the SAVEAS HTML function in Excel?

Hi Chaim,

The following works in Excel 2003

#DEFINE xlHtml	44	
oWorkbook.SaveAs(lcHtmFileName, xlHtml)