I am trying to SaveAs an Excel document to type .htm from Visual Foxpro. I thought that I had the correct syntax, but I keep getting an error that "Member SaveAs does not evaluate to an object.
Here is the code:
oExcel = CreateObject( "Excel.Application" )
oExcel.WorkBooks.Add
oExcel.Sheets(1).Select
oExcel.Range("A4").Select
oExcel.ActiveCell.FormulaR1C1 = "Account Number"
oExcel.Activeworkbook.SaveAs.Filename ="excel.htm"
TIA,
Steve McMahon
ZDI
San Diego
Steve McMahon
ZDI
San Diego