>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.
If it's not broken, fix it until it is.
My Blog