First of all, just want to thank you for all of the information you've made available to everyone. Going through the code in your cDataSet project has been... enlightening. So, again, thanks. But of course I have a question!
So I'm attempting to access a private/protected google docs worksheet from VBA. Use it something like a database etc. I've looked into the Google API for all of this, but I'm still pretty new to programming and there's something I'm clearly not getting. I'm using this documentation as a frame of reference:
Basically I need some guidance on how to plug in all of this information into your cbrowser/googleWireExample work. I've created and setup the API access through Google (Excel would be considered an "installed application", right?) I've been messing around with it for a few days now and I just can't get it sorted out. When I set a practice workbook to public, I can get the information no problem. So I'm not completely lost, hopefully!
Basically, as I understand it, I need to:
1. Send a query (with specific parameters from the API console. Client ID, Client Secret, Redirect URI?) to Google.
2. Get an access code/token as response
3. Somehow use the taken info + the desired data location to harvest the data I need
Should I be using the "sWire = cb.httpGET(url)" the googleWireExample module to feed in the additional arguments? And what should I even have that initial URL pointing to? The workbook I want to get data from or something like "
https://spreadsheets.google.com/feeds" ?
I assume that the "oHttp.SetRequestHeader" parameters in the httpGET function also play a role in this whole process, but everything I've messed around with hasn't gotten me any closer. I just get a response about not being logged in etc. I don't know if I'm most of the way there or completely off the grid, and it's a little frustrating.
Thank you in advance for any help you can provide. And thanks again for providing such valuable resources for everybody to use. Let me know if I can offer any further details to help solve the problem.