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 ---