Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening a EXCEL file on specific worksheet
Message
 
 
À
20/07/2008 19:07:30
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01332672
Message ID:
01332685
Vues:
16
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(lcXlsFile)
oSheet = oWorkbook.Sheets(lcSheetName)
* Activate selected sheet
*oSheet.Activate()
* Make Excel visible
*oExcel.Visible = .T.

* Get value from a cell with some formula
lnSum = oSheet.Cells(74,"d").Value
...
>
>1º
>I want to know how can build VFP coding to opening an EXCEL file existing on determinate drive (for ex: f:\) , and after opening this file on specific worksheet.
>
>2º
>Also, if a have a cell on Excel that return some kind of result calculation, i want to store this value on memory after closing my excel file and
>i want populate my VFP application with this value. It is possible..??
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform