Create a Google Calendar event with VBA

[brokkel]

I have searched the Internet but have not found anything worthwile.
Has anyone any idea whether this can be achieved?

Many thanks!

 

[brokkel]

One thing I found already is how to log on to the calendar:

Dim HTMLDoc As HTMLDocument
Dim oBrowser As InternetExplorer
Dim oHTML_Element As IHTMLElement
Dim sURL As String
On Error GoTo Err_Clear
sURL = "url"
Set oBrowser = New InternetExplorer
oBrowser.Silent = True
oBrowser.timeout = 60
oBrowser.Navigate sURL
oBrowser.Visible = true
Do
' Wait till the Browser is loaded
Loop Until oBrowser.ReadyState = READYSTATE_COMPLETE
Set HTMLDoc = oBrowser.Document
HTMLDoc.all.email.Value = "enteremail"
HTMLDoc.all.passwd.Value = "*******"
For Each oHTML_Element In HTMLDoc.getElementsByTagName("input")
If oHTML_Element.type = "submit" Then oHTML_Element.Click: Exit For
Next
' oBrowser.Refresh ' Refresh If Needed
Err_Clear:
If Err <> 0 Then
Err.Clear
Resume Next
End If

 

[brokkel]

anyone can add anything to this? Would be great

 

[Dmak]

Going to have to bump this. I too have looked around for a solution but nothing solid yet.

Has anyone got anything working with regard to this?

 

[Dmak]

As an alternative I'm tempted to use Google app sync, as linked below.

https://tools.google.com/dlpage/gappssync

Sending events to outlook should be easy enough.

It would be nice to go direct though.

 

[GBalcom]

3 years later....I'll bump this thread, I'm having the same problem. Has anyone solved this?

I've been using CData's ODBC Link, but for whatever reason it's giving me fits. I'd like to find another solution. I don't have Outlook.

 

[GBalcom]

Bump....

I'm curious if this is still an issue for others.

I've found an article showing how to create and reference a .net DLL File, but don't know much about visual studio, so I'll need to really dig in to utilize this.

Here's the article: https://www.codeproject.com/Articles/555660/Extend-your-VBA-code-with-Csharp-VB-NET-or-Cpluspl

 

[jdraw]

I don't use c# nor Google calendar.
I did find a few links via google that may be of use (if you don't already have them).

Create a DLL by CSharp or VB.Net for VBA

How to register, reference, and invoke the DLL from VBA or VB editor.

Google calendar api

Good luck.

 

[GBalcom]

One last bump....

Looking into this again.

I did find this other thread, but it appeared to die, and not have a good end result.

https://www.utteraccess.com/forum/index.php?showtopic=2041518&st=40

 

[theDBguy]

One last bump....

Looking into this again.

I did find this other thread, but it appeared to die, and not have a good end result.

https://www.utteraccess.com/forum/index.php?showtopic=2041518&st=40

Some people said they had success with it but others said they had problems with it. What did you get?

 

[GBalcom]

I don't have an account on Utteraccess.com. I'll create one, but not sure it will let me download anything without a few posts under my belt there.

 

[theDBguy]

I don't have an account on Utteraccess.com. I'll create one, but not sure it will let me download anything without a few posts under my belt there.

I see. Let me know if you run into any issues, but we probably should continue the discussion there. I'll keep an eye for your post there. Cheers!

 

[mike6271]

Just to let you know it worked for me. Thanks for link.

 

[theDBguy]

Just to let you know it worked for me. Thanks for link.

Hi. Thanks for the update. Glad to hear you got it working. Good luck with your project.