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:profoxtech-bounces@leafe.com] On Behalf Of Dave Crozier Sent: Monday, August 15, 2016 9:18 AM To: profoxtech@leafe.com 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]