Thank you, Victor
i will study your files and , may be, ask questions.
All the best
Kamil
>Hello:
>We wrote a program to do just that. Using an Excel format it converts it to a full reports. Unfortunately, I'm not able to share it by company policies, but I'm attaching a format Excel Sheet and the resulting output to give an idea of how it works. We are using ot to automate BI reports using Excel advanced features, conditional formatting and Pivot Tables, with no effort.
>
>>Good day.
>>I am writing a VFP app that would transfer financial indicators into Excel tables.
>>I would like to make it flexible so here is my idea.
>>In a cell where an indicator should be placed i edit the comment. A VFP explression is entered into the comment.
>>Something like Foo(Id1)+Foo(Id2)...
>>Foo being a function that returns a numeric value of the financial indicator.
>>Id1 is an identifier of an indicator.
>>The app checks the cells for not empty(.Comment) and then evaluates the comment string and puts the result in the cell's value.
>>
>>Is it a viable solution?
>>Maybe there is a better one, i would not like to reinvent a bicycle here.
>>
>>Regards
>>Kamil
A moment of silence is our cosmic reset button.