>>>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 think it's possible. You would analyze the selected range and assign values from columns to field values.
>>
>>I have a function which imports Excel sheet into a DBF. I think this function can be used as a starting point...
>>
>>It also probably can be done through Clipboard functions, but I'm not sure yet how.
>
>Thanks
Clipboard would be faster, if it can be done: A speed bottleneck is, how many messages are exchanged between VFP and Excel.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)