Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error opening Excel file
Message
From
16/12/2011 02:48:25
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
15/12/2011 17:39:57
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01531156
Message ID:
01531173
Views:
57
This message has been marked as the solution to the initial question of the thread.
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform