I had necessity from the VFP5 program to create small (no more than 20 pages), but rather complex Word97 document. With use OLE everything turns out well, but very slowly (about hour on P200/64), similar program on VBA (that was WordBasic) is carried out from force minute!
Whether who cannot say ideas for the decision of this problem?

My ideas:
1. Use DDE - is very inconvenient (through DDE it is possible to transfer only text; fonts, tables and other should be coded in Fox and decoded in Word)
2. To write VBA procedures (or objects), which would carry out large pieces of a code - for example, creation of the table and create it style. At such approach the quantity of calls of procedures OLE will decrease on the order. But here there are the problems: a call and transfer of parameters to procedures VBA or creation and transfer of the pointers on objects VBA in Fox. Besides it would be very good to have from Fox access to variable VBA.
3. Generation from Fox of the text of the program on VBA - ideal variant: in Fox everything flys by second, VBA works with acceptable speed. There are the problems: the text of the program turns out more allowable in VBA of the size - is solved by division on a few procedures and allocation of the subroutines; a main problem: how to automate import of a created BAS-file.

If you have other ideas or who knows a way of the decision of the specified problems, I very ask to respond.
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorry - my english is very bad; if you want get russian text or have questions, send me e-Mail: incom@penza.com.ru.