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

Hi,
I have the same problem with a VBA macro. The AdvancedSearchComplete event
never happens; the module is not called by the main code. Can anyone help us
explaining because code is wrong?

Thank you for your attention
Bye

"(E-Mail Removed)" ha scritto:

> 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
>
>

It's going to be hard to help you without seeing a code snippet.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"VBrogna" <(E-Mail Removed)> wrote in message news:CDC3F05E-22D5-4A6F-A46B-(E-Mail Removed)...
> Hi,
> I have the same problem with a VBA macro. The AdvancedSearchComplete event
> never happens; the module is not called by the main code. Can anyone help us
> explaining because code is wrong?