General information
Category:
COM/DCOM and OLE Automation
>I am trying to export a dbf to Ms excel with a the help of VFP2Excel function.
>There is a field in dbf where I created an excel function but it wont execute when exported.
>The function only executes when I open the MS Excel file and click on the cell.
>How can I make the function execute automatically when exported to MS Excel?
>
>Thanks
>T.
If I understand it correctly, you have VFP dbf table where one of the fields contains expression that if exported to Excel, it is recognized like a formula that can be or should be implemented.
What I do not understand is:
- If, say, there are several recors in Excel sheet, do you need to click on each cell in the column that cointains formulas?
- what "execute automatically" means? Does it mean that if you open Excel, formula(s) should work on file opening and without user intervention? Or it means that when exporting to excel, Excel function should work first creating/modifying data and then Excel file should contain only the result ?
Yuri
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only