>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?
I believe in Excel, if VBA/Macro security is set too high, automation won't work. I think by default it's fairly strict. You can set lower values by enabling the Developer tab (
http://www.peppercrew.nl/index.php/2010/06/enable-vbamarcos-in-excel-2010/ ), then going into "Macro Security" and experimenting with the options.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up