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?

Thanks!