Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Account Loves Excel
Message
 
À
02/08/1999 02:02:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00248748
Message ID:
00248781
Vues:
19
My suggestion is to start with an empty excel workbook. Then, for each month, you could issue code like this:

oExcel = Createobject("excel.application")
oWorkBook = oExcel.WorkBooks.Add

Then, for each month:

oWorkSheet = oWorkBook.WorkSheets.Add

So, if you have an existing workbook, you could do this:

oExcel = Createobject("excel.application")
oWorkbook = oExcel.Workbooks.Open("inventory.xls")

Once you have an object reference to a specific worksheet, you can use automation to populate the cells.

IMHO, this method will provide more granular control than the COPY TO command.

HTH...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform