VFP9 - Save as XLSX

Author: Desmond Lloyd

Posted: 2018-04-16 at 11:17:40

Good Morning,

Need to be able to copy the contents of a cursor to an Excel file, but it

needs to be in the xlsx.

Am a newbie to Excel Automation and have read that you can saveas, and it

will save in the latest format. Well mine doesn't. oworkbook.version

shows 16. (we are running Office 365)

Tried the SweetPotato method but it errors out. Not sure why.

Would someone be kind enough to point me in the right direction, with some

possible examples...

TIA,

Desmond

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

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/CAAJXvaO8wEyx8xhag_vPXzK48N2wDbhLE9qYKdzCvMkMEvyDyQ@mail.gmail.com

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

©2018 Desmond Lloyd