Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel and Selecting Entire Workbook...How?
Message
De
30/04/2002 15:33:02
 
 
À
29/04/2002 11:38:39
N. Lea
Nic Cross Enterprises
Valencia, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00650432
Message ID:
00651056
Vues:
18
>
>		#DEFINE xlDBF3	8	
>		oExcel = CreateObject("Excel.Application")
>		oExcel.Workbooks.Open(.pcapdatapath + "upgrade.xls")
>		erase sample.dbf
>		oExcel.ActiveWorkbook.SaveAs(.pcardatapath + "upgrade.dbf", xlDBF3)
>		oExcel.Activeworkbook.Close(0)
>
Maybe you miss this line:
#DEFINE xlDBF3	8
#DEFINE xlLastCell 11
*** snip ***
erase addbs(.pcardatapath) + "upgrade.dbf"

**>>> Select the last cell with data
oExcel.ActiveCell.SpecialCells(xlLastCell).Select
**<<< end additional code

oExcel.ActiveWorkbook.SaveAs(addbs(.pcardatapath)+"upgrade.dbf", xlDBF3)
oExcel.Activeworkbook.Close(0)
HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform