Well, you certainly have to have SOME rules on the data structure. I only gave examples. The point is, you can't work with totally unstructured data, which can only be interpreted by humans. Another point is that any rule must be agreed upon (or enforced by the programmer).
Naming a cell might be an alternative, another might be to have the data right below a certain text (i.e. the title), and search for that.
>Hilmar
>
>I was hoping to find a way to avoid having such rigid rules. Sometimes the budget is calculated in Excel; for example, they may know the total budget, and then allocate it on a percentage basis to each salesperson. It would be good to give them the flexibility to calculate the budget in any way they want.
>
>Perhaps one can name a cell that contains the starting data? I wonder if that will work, and if one can detect the named cell when importing into VFP.
>
>Thanks for the suggestion.
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)
