Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Useful DBF2Excel routine
Message
De
17/02/2006 16:39:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Useful DBF2Excel routine
Divers
Thread ID:
01097203
Message ID:
01097203
Vues:
80
Oops, just googled Dbf2Excel and found FoxyClases is using that name for one of their classes. Sorry about that.

Alex

Hi,

I needed this little routine and thought it may be useful to others:
* DBF2Excel.prg This routine is meant to be called with a table open in current area
* Creates table in FOX2X format and opens with Excel
LOCAL lcTemp,loExcel
lcTemp = FORCEPATH(SYS(2015) + '.tmp',SYS(2023))
COPY TO (lcTemp) FOX2X
loExcel = CREATEOBJECT('Excel.Application')
loExcel.WindowState = -4137  && xlMaximized 
loExcel.Workbooks.Add(lcTemp)
loExcel.Visible = .t.
Alex
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform