Fred: Wow. That sounds like an interesting project! I know a little bit about Fox access to Microsoft Office, having spent a couple years writing some big automation apps (and editing a book) and automating OpenOffice (and writing a FoxTalk article), and doing a lot of work automating MSGraph, but I hadn't thought there'd be a way to do the Google Apps.
I've found instructions on setting up your Google Drive for offline access, which should give you local file access. https://lifehacker.com/how-to-make-google-drive-work-like-a-desktop-suite-1557341520 And there's a Google Apps Scripting language: https://developers.google.com/apps-script/ But I'm not seeing the VFP-to-GApps interface. I don't think there's a COM, DCOM, or even DDE interface. I'm guessing you'd need to do something along the lines of HTTP Posts and Fetches using something like: https://developers.google.com/apps-script/guides/services/external Let me know if you find more info on this, as I could see this is something I'd like to work with, too. On Tue, May 9, 2017 at 1:51 PM, Fred Taylor <[email protected]> wrote: > Can anybody point me to some simple example code to access Google Sheets > from VFP? > > I had some code a few months ago, but now that I actually need it, I can't > find it again. <sigh> > > Thx, > > Fred > > > --- 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/CACW6n4vuB8rtBtLoQD6bmaWk1fAy4MtpgtUVOC5nO7=iep2...@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.
