Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening a EXCEL file on specific worksheet
Message
 
 
To
20/07/2008 19:07:30
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01332672
Message ID:
01332685
Views:
15
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform