Just an untested idea, Dave, but can you save the embedded object to a temporary, sys(3)-named file, query it as you usually would, and then delete it?
Mike -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Monday, August 15, 2016 9:18 AM To: [email protected] Subject: Embedded Excel... I have been forced to bite the bullet on a small project and use embedded OLE Excel objects as general fields in a VFP table. Although totally against my principles where I would normally save the link to a physical Excel sheet and then open it up as a com object, is there anyone who knows how I can drive the embedded Excel object in the same way that you can when using Automation? Ideally I want to query the embedded Excel and pull back a named range of cells. Into VFP. Any ideas? Dave --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
