>Hi,
>
>I want to create a Excel file from VFP program.
>
>1. how to crate a Excel file ( that with 3 sheets, as like as the blank worksheet when i run EXCEL )
>
You'd use Excel's automation model; you can open worksheets, address pages, populate ceels and more with the automation model. There's a FoxPro-specific book that discusses Office automation, including Excel, by Tamar Granor and Della Martin, availabe from
www.hentzenwerke.com (you have to but it) that covers the Excel automation interface.
>2. how can i define the number of sheet at that Excel ?
>
Again, done with automation. You need to learn about Excel's automation object model to do much of anything,
>3. how can i define the name of sheet1, sheet2....3
>
They're properties accessed by the automation model.
>4. after created, how can i change the ACTIVE SHEET ?
> ex. i want to put some value into
> .cell(1,1) = "page 1 - 101" into sheet1
> .cell(1,2) = "page 1 - 102" into sheet1
> .cell(1,1) = "page 2 - 201" into sheet2
> .cell(1,2) = "page 2 - 201" into sheet2
>
Automation.