Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VBA for Excel 2000 SaveAs
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
VBA for Excel 2000 SaveAs
Divers
Thread ID:
00331789
Message ID:
00331789
Vues:
59
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform