H
hardvark
Hi,
I have to retrieve some data from outlook using a VBA macro in Excel.
According to the documentation this code is supposed to work. But the
outlookApp_AdvancedSearchComplete event never fires. I have run out of
ideas. Any help would be greatly appreciated.
Sub Button1_Click()
Dim outlookApp As New Outlook.Application
Dim objSearch As Outlook.Search
Set objSearch = outlookApp.AdvancedSearch("Tasks")
End Sub
Private Sub outlookApp_AdvancedSearchComplete(SearchObject As Search)
MsgBox 'found something'
End Sub
I have to retrieve some data from outlook using a VBA macro in Excel.
According to the documentation this code is supposed to work. But the
outlookApp_AdvancedSearchComplete event never fires. I have run out of
ideas. Any help would be greatly appreciated.
Sub Button1_Click()
Dim outlookApp As New Outlook.Application
Dim objSearch As Outlook.Search
Set objSearch = outlookApp.AdvancedSearch("Tasks")
End Sub
Private Sub outlookApp_AdvancedSearchComplete(SearchObject As Search)
MsgBox 'found something'
End Sub