>Considerable effort was put into troubleshooting this issue on affected machines, without success.
>
>The final resolution was to replace Excel automation with the use of Greg Green's VFPx class:
https://github.com/ggreen86/XLXS-Workbook-Class .
>
>My gut feel is the future will see increasing restrictions/lockdowns on inter-process communications, function calls, automation etc both by Windows and by security/AV programs. My recommendation would be to eliminate Excel automation where feasible and replace it with this class.
We have been and still using excel automation w/o no problems. It is better and much faster than alternatives. Using CopyFromRecordset has always worked successfully (even with 64 bits office - via VFPOLEDB saving to a stream and opening the stream in excel) - you may find many samples of my VFP2Excel routines on the internet I believe.