Hi,
An automation process that used to work is now failing, in Excel 2010, for security reasons. Apparently Excel finds the idea of being automated to open an Excel file suspicious.
The relevant commands are:
copy to (lcTempFile) type XLS
...
loWorkbookTemp = This.oExcel.oApp.Workbooks.Open(lcTempFile)
Excel - if it was previously open - says something about the trust center (similar to the message below, shown in Visual FoxPro).
After accepting the message in Excel, Visual FoxPro gives the error message "You are attempting to open a file type that is blocked by your File Block settings in the Trust center..."
I have used COPY TO ... TYPE XLS to make an Excel automation faster - transfer an entire DBF at once - since transferring one cell at a time would be exceedingly slow, especially for large files.
Any ideas, how best to handle this?
TIA,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)