Dave Crozier wrote on 2016-08-15: > 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 >
Dave, So using automation to pull the information into a cursor then using CursorToXml to store the data from the spreadsheet is out of the question? The only other thing I can suggest is to STRCONV the actual XLS file to a string that you can store in a MEMO field. Tracy Pearson PowerChurch Software _______________________________________________ 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.
