>>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.
>
>Well, if it allows automation at all, my favorite method of populating a sheet is to do
>
>
>_vfp.datatoclip(,,3)
>oExcel.Paste()
>
>
>Possibly removing the first line from the _cliptext, as it contains the field names, and/or selecting a cell other than (1,1) to paste to. This is rather fast - I remember I used that in 2005 to churn about 20 megabytes of excel sheets in a couple of minutes.
Thanks. That method is great, and it is what I'll be using. There are, however, some problems with it.
(1) If Visual FoxPro and Excel (via the Control Panel) have different date formats, the dates will be inserted incorrectly. That's not a problem in my case, since I already had SET SYSFORMATS ON in any case.
(2) For memo fields, the text "memo" gets inserted into Excel. The cursor to be copied can be prepared in advance (by converting the memo to character), but - in my case - since this is used for a generic report, possibly for hundreds of reports, it may require a lot of individual adjustments.
(3) Unlike the COPY TO ... XLS method, the column widths will not adjust to the size of the field.
These are no serious problems for me, but I wanted to mention them for completeness sake.
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)