Google calender retrive and update via macro.

[hmaleki]

Hi dears
Thank you for your time and attention.

I need an Excel VBA macro to do the following:
login to google calendar, retrieve calendars and calendar items (by event id, and/or by date & time, and/or by text within event title). Make updates to the events and repost them. The login credentials and information to be retrieved can all be hardcoded in the code. If possible I would like it done using msxml2.serverxmlhttp since that is how I access my other web APIs but that is not a requirement.



In other way, What I need is to be able to interact with the calendar the same way you would online but via an excel VBA program. I need to post new events, retrieve and modify existing events (change date, time, add reminder, set to confirmed, etc.) - I assume this would be done via UID but since I wouldn't know the UID for events created online I would also need to be able to find events (kind of like Mozilla Thunderbird). I really just need to know how to do the authorization and what the syntax of all of the requests is that is why hardcoding is fine. Once I have that I will modify the code so that my program can find the events it needs by building the requests itself.

now i don't find any source to use msxml2.serverxmlhttp for this connection, if it's not possible please let me know how can do this regards.

[Kenneth Hobson]

http://lmgtfy.com/?q=google+calendar+api

[hmaleki]

Hi @kenneth Hobson
Thank you for your response but I want created excel based google calender app. I want get events in google sheet and then update them and upload.