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-15...
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 fbtaylor@gmail.com 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]