Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I Finally Got FoxPro and Excel to Work Together!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
I Finally Got FoxPro and Excel to Work Together!
Divers
Thread ID:
00122058
Message ID:
00122058
Vues:
59
Thanks to those who helped me load an Excel spreadsheet by calling Excel from FoxPro.

I wanted a straight-forward approach, without needing to utilize libraries or DDE. So, here's what I came up with:

-----

loTempSheet = GetObject('','excel.sheet')
oVar.ExcelApp = loTempSheet.Application
oVar.ExcelApp.Visible = .T.
oVar.ExcelApp.Workbooks.Open("c:\agetemp")

-----

"oVar" is a public variable I use for attaching variables as properties. This way, I can keep all public variables in one place, as an object.

The "agetemp" Excel file is created beforehand, after a selection is made on a grid.

Thanks a LOT!

Michael Reynolds
Répondre
Fil
Voir

Click here to load this message in the networking platform