Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement