Steve,

The answer depends on what you have in the code. So here are some common things.

1. I would avoid any interaction Excel-VFP on tables open in both and at the very same time: Excel is not supposed to work in multiuser environment.

If for some reason you need to work from VFP with Excel document having automacros, then close tables in VFP or switch off Excel Macro.

2. I believe you do not close the program completely or the VFP object created in Excel is still running. Perhaps you need to close libraries, or clear events, or release public variables if any, etc. But I cannot tell you exactly what to do whithout seeing your code.

Best Wishes


>Dear Yuri,
>
>Coming back to my old problem, "Excel opening minimised through VFP", do you think these leads are useful ?:
>
>1. Macros within Excel use the same open tables which are in use in VFP.These macros instantiate when the Excel file is opened. The macro uses a CreateObject everytime VFP is initiated. So do you think this is generating an error, causing a read-only status, due to multiple instantiation of a table ?
>2.Everytime the vfp prog runs (to create or open an Excel file), after the program is over, the programme does not respond correctly to commands. For example, if 'use xyz'( a non-existent file) is typed in the command window it returns a messagebox-"operator Operand type mismatch", and has a titlebar heading "Program Error", even though I am out of the program.
>
>Would you be kind enough to share any code with me on this error, if possible ? Besides, would you be able to tell me why my actual errors, if any are not being displayed through the normal messagebox process, and how I can get either excel, or vfp to do so, so that I know where I stand, in the first place ?
>
>Thanks Yuri,
>
>With best regards,
>
>Steve.