Kamil:

Never forget KISS - Keep it simple stupid. Doing what you suggest can lead to:

(1) You will have VFP code in an Excel sheet that has to be read and evaluated in a program and can lead to difficult to find errors. I would not want to debug the process.

(2) Modifying the a VFP program when the user changes the specs isn't that big of a deal and eventually users settle on a report(s) they are happy with and things stabilize, at least in my 45 years of experience.

(3) VFP and Excel working together is problematic enough (but manageable and easy to follow) with the information going one direction, from VFP to Excel and having it flow both ways just makes things less reliable, i.e. more work for you.

(4) If the accountants are constantly changing the reports then it sounds like they are likely hunting for a good solution so providing them with all the data they would ever imagine using in a spreadsheet that they can then toy with in developing ad hoc reports can work. Once they've found a satisfactory solution you can program to that spec.

Just my humble opinion,

Scott

>>If the function is an excel function, why not simply put the expression in the .formula property of the cell? If, OTOH, it's a VFP function, why not just store the result?
>>
>>The elegance of the answer would depend a lot on the circumstances - like, is this a sheet you are generating from Fox periodically, or is it a permanent sheet that you update from Fox, and in the latter case, whether the numbers in it all come from Fox or from other sources too (like manual entry or being created/updated by other software).
>
>Hello , Dragan
>My main desire is to achieve flexibility. Accountants are prone to changing their reports. If i store the results from the app directly into cells then every time a report (xls) changes i will have to rewrite the VFP code. If , on the other hand, i store in a comment a VFP expression that the app just evaluates, then what i have to do is to supply a new xls which tells the app what to do and i don't have to rewrite the code.
>
>Regards
>Kamil