>>I have a VFP screen into which I want to import a range from an existing XLS sheet
>>I imagine having the screen open in VFP. By prssing a button the excel sheet comes to the forground. I highlight a range let's say k144:o162 and by either copying it to the clipbord or executing an excel macro pushing the values of the range into an array and returning it into a VFP array
>>
>>is this possible?
>>
>>
>>Peter
>
>I'm almost certain it is. A little different from what you describe: Highlight a range, and then push a button on your VFP-form. I assume your Excel-session is in a property of the form:
>
>THISFORM.oExcel
>
>Then check the properties of THISFORM.oExcel.Selection
>
>I don't know how they are named, but you can find out the left-upper-cell and the right-lower as properties of the object THISFORM.oExcel.Selection. After that you just do a FOR-loop in Fox to fill an array.
>
>Sorry I have no prefab code for you, hopes this gives enough direction.
>
>Lennert
thanks, That's all I need
Peter
Peter Cortiel