Create a Google Calendar event with VBA (1 Viewer)
- Thread starter brokkel
- Start date
One thing I found already is how to log on to the calendar:
Code:
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
Last edited by a moderator:
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.
https://tools.google.com/dlpage/gappssync
Sending events to outlook should be easy enough.
It would be nice to go direct though.
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.
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.
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
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
- Local time
- Today, 12:08
- Joined
- Jan 23, 2006
- Messages
- 15,379
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.
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.
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
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
- Local time
- Today, 09:08
- Joined
- Oct 29, 2018
- Messages
- 21,449
Some people said they had success with it but others said they had problems with it. What did you get?
- Local time
- Today, 09:08
- Joined
- Oct 29, 2018
- Messages
- 21,449
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!
- Local time
- Today, 09:08
- Joined
- Oct 29, 2018
- Messages
- 21,449
Hi. Thanks for the update. Glad to hear you got it working. Good luck with your project.
