Run .dll programatically

[hlock]

Outlook 2007 - Our document management system has an Outlook exchange client

extension that allows us to import an email directly to the document

management system. We click on an email, click on the command button and the

import dialogue box launches. After searching, I found that the ECE points

to a .dll in regedit. Ultimately, we want to create a macro that asks the

user to import attachments. If the user chooses Yes, that ece above runs.

If the user chooses No, another macro runs. How do I write the code to

invoke the .dll when the user chooses Yes. Not being very literate in

programming, I would appreciate any help. Thanks.

 

[Sue Mosher [MVP]]

Any mechanism to invoke the .dll programmatically would have to be exposed

by the original programmer of that .dll. In other words, it's not something

we can help you with. You'll need to ask the creator of the document

management system.

Sue Mosher

"hlock" <hlock> wrote in message

news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> Outlook 2007 - Our document management system has an Outlook exchange
> client
> extension that allows us to import an email directly to the document
> management system. We click on an email, click on the command button and
> the
> import dialogue box launches. After searching, I found that the ECE
> points
> to a .dll in regedit. Ultimately, we want to create a macro that asks the
> user to import attachments. If the user chooses Yes, that ece above runs.
> If the user chooses No, another macro runs. How do I write the code to
> invoke the .dll when the user chooses Yes. Not being very literate in
> programming, I would appreciate any help. Thanks.

 

[hlock]

Oh boy - it seemed too easy. All we wanted to do was "click" on the toolbar

button through visual basic rather than actually clicking on it with the

mouse.

"Sue Mosher [MVP]" wrote:


> Any mechanism to invoke the .dll programmatically would have to be exposed
> by the original programmer of that .dll. In other words, it's not something
> we can help you with. You'll need to ask the creator of the document
> management system.

> > Sue Mosher
> > >

> "hlock" <hlock> wrote in message
> news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> > Outlook 2007 - Our document management system has an Outlook exchange
> > client
> > extension that allows us to import an email directly to the document
> > management system. We click on an email, click on the command button and
> > the
> > import dialogue box launches. After searching, I found that the ECE
> > points
> > to a .dll in regedit. Ultimately, we want to create a macro that asks the
> > user to import attachments. If the user chooses Yes, that ece above runs.
> > If the user chooses No, another macro runs. How do I write the code to
> > invoke the .dll when the user chooses Yes. Not being very literate in
> > programming, I would appreciate any help. Thanks.

> .
>

 

[Sue Mosher [MVP]]

Clicking on the button might be possible, but that's not the way I read your

request. If that's all you want to do, tell us the name of the toolbar and

the caption the button uses, including any accelerator keys.

Sue Mosher

"hlock" <hlock> wrote in message

news:A2A9A3B2-4517-4D4F-81DE-8B772DFFD59A@microsoft.com...
> Oh boy - it seemed too easy. All we wanted to do was "click" on the
> toolbar
> button through visual basic rather than actually clicking on it with the
> mouse.

> "Sue Mosher [MVP]" wrote:
>
> > Any mechanism to invoke the .dll programmatically would have to be
> > exposed
> > by the original programmer of that .dll. In other words, it's not
> > something
> > we can help you with. You'll need to ask the creator of the document
> > management system.
>

>> "hlock" <hlock> wrote in message
> > news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> > > Outlook 2007 - Our document management system has an Outlook exchange
> > > client
> > > extension that allows us to import an email directly to the document
> > > management system. We click on an email, click on the command button
> > > and
> > > the
> > > import dialogue box launches. After searching, I found that the ECE
> > > points
> > > to a .dll in regedit. Ultimately, we want to create a macro that asks
> > > the
> > > user to import attachments. If the user chooses Yes, that ece above
> > > runs.
> > > If the user chooses No, another macro runs. How do I write the code to
> > > invoke the .dll when the user chooses Yes. Not being very literate in
> > > programming, I would appreciate any help. Thanks.

 

[hlock]

We'll take what we can get. The addin is being very difficult. The button

is on the Standard Toolbar and is captioned "Save to Vignette IDM". The

addin is also under the File menu captioned "Save to Vignette IDM". No other

key strokes. Other info - the registry key has a value name of TOWER E-MAIL

CAPTURE and a value data of 4.0;C:\Program

Files\Tower\ttoutext.dll;1;01000010000000;1100000100. Is there anything else

you need?

"Sue Mosher [MVP]" wrote:


> Clicking on the button might be possible, but that's not the way I read your
> request. If that's all you want to do, tell us the name of the toolbar and
> the caption the button uses, including any accelerator keys.
> > Sue Mosher
> > >

> "hlock" <hlock> wrote in message
> news:A2A9A3B2-4517-4D4F-81DE-8B772DFFD59A@microsoft.com...
> > Oh boy - it seemed too easy. All we wanted to do was "click" on the
> > toolbar
> > button through visual basic rather than actually clicking on it with the
> > mouse.
> > "Sue Mosher [MVP]" wrote:
> >
> >> Any mechanism to invoke the .dll programmatically would have to be
> >> exposed
> >> by the original programmer of that .dll. In other words, it's not
> >> something
> >> we can help you with. You'll need to ask the creator of the document
> >> management system.
> >
> >> "hlock" <hlock> wrote in message
> >> news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> >> > Outlook 2007 - Our document management system has an Outlook exchange
> >> > client
> >> > extension that allows us to import an email directly to the document
> >> > management system. We click on an email, click on the command button
> >> > and
> >> > the
> >> > import dialogue box launches. After searching, I found that the ECE
> >> > points
> >> > to a .dll in regedit. Ultimately, we want to create a macro that asks
> >> > the
> >> > user to import attachments. If the user chooses Yes, that ece above
> >> > runs.
> >> > If the user chooses No, another macro runs. How do I write the code to
> >> > invoke the .dll when the user chooses Yes. Not being very literate in
> >> > programming, I would appreciate any help. Thanks.

> .
>

 

[Sue Mosher [MVP]]

This VBA macro should execute that button on the Standard toolbar in an

Explorer window:

Sub RunIt()

Dim cb As Office.CommandBar

Dim cbb As Office.CommandBarButton

Dim ctrl As Office.CommandBarControl

Dim exp As Outlook.Explorer

Set exp = Application.ActiveExplorer

Set cb = exp.CommandBars("Standard")

For Each ctrl In cb.Controls

If ctrl.Caption = "Save to Vignette IDM" Then

Set cbb = ctrl

cbb.Execute

Exit For

End If

Next

Set cb = Nothing

Set cbb = Nothing

Set ctrl = Nothing

Set exp = Nothing

End Sub

Sue Mosher

"hlock" <hlock> wrote in message

news:3D6657F2-FB29-42DF-A5E3-DFFE43989356@microsoft.com...
> We'll take what we can get. The addin is being very difficult. The
> button
> is on the Standard Toolbar and is captioned "Save to Vignette IDM". The
> addin is also under the File menu captioned "Save to Vignette IDM". No
> other
> key strokes. Other info - the registry key has a value name of TOWER
> E-MAIL
> CAPTURE and a value data of 4.0;C:\Program
> Files\Tower\ttoutext.dll;1;01000010000000;1100000100. Is there anything
> else
> you need?

> "Sue Mosher [MVP]" wrote:
>
> > Clicking on the button might be possible, but that's not the way I read
> > your
> > request. If that's all you want to do, tell us the name of the toolbar
> > and
> > the caption the button uses, including any accelerator keys.
>

>> "hlock" <hlock> wrote in message
> > news:A2A9A3B2-4517-4D4F-81DE-8B772DFFD59A@microsoft.com...
> > > Oh boy - it seemed too easy. All we wanted to do was "click" on the
> > > toolbar
> > > button through visual basic rather than actually clicking on it with
> > > the
> > > mouse.
> >> > "Sue Mosher [MVP]" wrote:
> >> >> Any mechanism to invoke the .dll programmatically would have to be
> > >> exposed
> > >> by the original programmer of that .dll. In other words, it's not
> > >> something
> > >> we can help you with. You'll need to ask the creator of the document
> > >> management system.
> > >
>> >> "hlock" <hlock> wrote in message
> > >> news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> > >> > Outlook 2007 - Our document management system has an Outlook
> > >> > exchange
> > >> > client
> > >> > extension that allows us to import an email directly to the document
> > >> > management system. We click on an email, click on the command
> > >> > button
> > >> > and
> > >> > the
> > >> > import dialogue box launches. After searching, I found that the ECE
> > >> > points
> > >> > to a .dll in regedit. Ultimately, we want to create a macro that
> > >> > asks
> > >> > the
> > >> > user to import attachments. If the user chooses Yes, that ece above
> > >> > runs.
> > >> > If the user chooses No, another macro runs. How do I write the code
> > >> > to
> > >> > invoke the .dll when the user chooses Yes. Not being very literate
> > >> > in
> > >> > programming, I would appreciate any help. Thanks.

 

[hlock]

Works like a charm! Now how would I do this if the email was open. The same

"Save to Vignette IDM" is located on the Ribbon on the Add-Ins tab in the

Toolbar Commands group. Thank you so much.

"Sue Mosher [MVP]" wrote:


> This VBA macro should execute that button on the Standard toolbar in an
> Explorer window:

> Sub RunIt()
> Dim cb As Office.CommandBar
> Dim cbb As Office.CommandBarButton
> Dim ctrl As Office.CommandBarControl
> Dim exp As Outlook.Explorer

> Set exp = Application.ActiveExplorer
> Set cb = exp.CommandBars("Standard")
> For Each ctrl In cb.Controls
> If ctrl.Caption = "Save to Vignette IDM" Then
> Set cbb = ctrl
> cbb.Execute
> Exit For
> End If
> Next

> Set cb = Nothing
> Set cbb = Nothing
> Set ctrl = Nothing
> Set exp = Nothing
> End Sub

> > Sue Mosher
> > >

> "hlock" <hlock> wrote in message
> news:3D6657F2-FB29-42DF-A5E3-DFFE43989356@microsoft.com...
> > We'll take what we can get. The addin is being very difficult. The
> > button
> > is on the Standard Toolbar and is captioned "Save to Vignette IDM". The
> > addin is also under the File menu captioned "Save to Vignette IDM". No
> > other
> > key strokes. Other info - the registry key has a value name of TOWER
> > E-MAIL
> > CAPTURE and a value data of 4.0;C:\Program
> > Files\Tower\ttoutext.dll;1;01000010000000;1100000100. Is there anything
> > else
> > you need?
> > "Sue Mosher [MVP]" wrote:
> >
> >> Clicking on the button might be possible, but that's not the way I read
> >> your
> >> request. If that's all you want to do, tell us the name of the toolbar
> >> and
> >> the caption the button uses, including any accelerator keys.
> >
> >> "hlock" <hlock> wrote in message
> >> news:A2A9A3B2-4517-4D4F-81DE-8B772DFFD59A@microsoft.com...
> >> > Oh boy - it seemed too easy. All we wanted to do was "click" on the
> >> > toolbar
> >> > button through visual basic rather than actually clicking on it with
> >> > the
> >> > mouse.
> >> >> > "Sue Mosher [MVP]" wrote:
> >> >> >> Any mechanism to invoke the .dll programmatically would have to be
> >> >> exposed
> >> >> by the original programmer of that .dll. In other words, it's not
> >> >> something
> >> >> we can help you with. You'll need to ask the creator of the document
> >> >> management system.
> >> >
> >> >> "hlock" <hlock> wrote in message
> >> >> news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> >> >> > Outlook 2007 - Our document management system has an Outlook
> >> >> > exchange
> >> >> > client
> >> >> > extension that allows us to import an email directly to the document
> >> >> > management system. We click on an email, click on the command
> >> >> > button
> >> >> > and
> >> >> > the
> >> >> > import dialogue box launches. After searching, I found that the ECE
> >> >> > points
> >> >> > to a .dll in regedit. Ultimately, we want to create a macro that
> >> >> > asks
> >> >> > the
> >> >> > user to import attachments. If the user chooses Yes, that ece above
> >> >> > runs.
> >> >> > If the user chooses No, another macro runs. How do I write the code
> >> >> > to
> >> >> > invoke the .dll when the user chooses Yes. Not being very literate
> >> >> > in
> >> >> > programming, I would appreciate any help. Thanks.

> .
>

 

[Sue Mosher [MVP]]

Commands on the Ribbon can't be executed programmatically from VBA, AFAIK.

Sue Mosher

"hlock" <hlock> wrote in message

news:802A7DEE-E55F-4ACD-A34D-EE042375792A@microsoft.com...
> Works like a charm! Now how would I do this if the email was open. The
> same
> "Save to Vignette IDM" is located on the Ribbon on the Add-Ins tab in the
> Toolbar Commands group. Thank you so much.

> "Sue Mosher [MVP]" wrote:
>
> > This VBA macro should execute that button on the Standard toolbar in an
> > Explorer window:
>

>> Sub RunIt()
> > Dim cb As Office.CommandBar
> > Dim cbb As Office.CommandBarButton
> > Dim ctrl As Office.CommandBarControl
> > Dim exp As Outlook.Explorer
>

>> Set exp = Application.ActiveExplorer
> > Set cb = exp.CommandBars("Standard")
> > For Each ctrl In cb.Controls
> > If ctrl.Caption = "Save to Vignette IDM" Then
> > Set cbb = ctrl
> > cbb.Execute
> > Exit For
> > End If
> > Next
>

>> Set cb = Nothing
> > Set cbb = Nothing
> > Set ctrl = Nothing
> > Set exp = Nothing
> > End Sub
>

>> "hlock" <hlock> wrote in message
> > news:3D6657F2-FB29-42DF-A5E3-DFFE43989356@microsoft.com...
> > > We'll take what we can get. The addin is being very difficult. The
> > > button
> > > is on the Standard Toolbar and is captioned "Save to Vignette IDM".
> > > The
> > > addin is also under the File menu captioned "Save to Vignette IDM". No
> > > other
> > > key strokes. Other info - the registry key has a value name of TOWER
> > > E-MAIL
> > > CAPTURE and a value data of 4.0;C:\Program
> > > Files\Tower\ttoutext.dll;1;01000010000000;1100000100. Is there
> > > anything
> > > else
> > > you need?
> >>> > "Sue Mosher [MVP]" wrote:
> >> >> Clicking on the button might be possible, but that's not the way I
> > >> read
> > >> your
> > >> request. If that's all you want to do, tell us the name of the toolbar
> > >> and
> > >> the caption the button uses, including any accelerator keys.
> > >
>> >> "hlock" <hlock> wrote in message
> > >> news:A2A9A3B2-4517-4D4F-81DE-8B772DFFD59A@microsoft.com...
> > >> > Oh boy - it seemed too easy. All we wanted to do was "click" on the
> > >> > toolbar
> > >> > button through visual basic rather than actually clicking on it with
> > >> > the
> > >> > mouse.
> > >>> >> > "Sue Mosher [MVP]" wrote:
> > >>> >> >> Any mechanism to invoke the .dll programmatically would have to be
> > >> >> exposed
> > >> >> by the original programmer of that .dll. In other words, it's not
> > >> >> something
> > >> >> we can help you with. You'll need to ask the creator of the
> > >> >> document
> > >> >> management system.
> > >> >
>> >> >> "hlock" <hlock> wrote in message
> > >> >> news7EECB05-6179-49C2-9956-705A65990B6A@microsoft.com...
> > >> >> > Outlook 2007 - Our document management system has an Outlook
> > >> >> > exchange
> > >> >> > client
> > >> >> > extension that allows us to import an email directly to the
> > >> >> > document
> > >> >> > management system. We click on an email, click on the command
> > >> >> > button
> > >> >> > and
> > >> >> > the
> > >> >> > import dialogue box launches. After searching, I found that the
> > >> >> > ECE
> > >> >> > points
> > >> >> > to a .dll in regedit. Ultimately, we want to create a macro that
> > >> >> > asks
> > >> >> > the
> > >> >> > user to import attachments. If the user chooses Yes, that ece
> > >> >> > above
> > >> >> > runs.
> > >> >> > If the user chooses No, another macro runs. How do I write the
> > >> >> > code
> > >> >> > to
> > >> >> > invoke the .dll when the user chooses Yes. Not being very
> > >> >> > literate
> > >> >> > in
> > >> >> > programming, I would appreciate any help. Thanks.
>

>
>> .
> >