Calling a private sub in Outlook via toolbar button

I need to add a button to my outlook toolbar called "send and file".
This button needs to call a subroutine that will send the message and
allow a user to choose a folder to save the message to (other than the
sent items). My subroutine is working correctly. However, I am unable
to link it to the toolbar because it is a private subroutine. How can
I trigger a private subroutine from a toolbar button?

Thanks very much for your help!

Hi sapphire,

sapphire wrote:
> I need to add a button to my outlook toolbar called "send and file".
> This button needs to call a subroutine that will send the message and
> allow a user to choose a folder to save the message to (other than the
> sent items). My subroutine is working correctly. However, I am
> unable to link it to the toolbar because it is a private subroutine.
> How can I trigger a private subroutine from a toolbar button?

I assume you're talking about Outlook VBA, not Excel. Regardless, there's
no way to call a Private subroutine from any location other than the module
itself. So you'd either need a Public wrapper subroutine, or you'll need to
make your routine Public. What's the reason for making it Private? If it's
to keep users from seeing it in a run macros dialog, you can use Option
Private Module at the top of the code module, which will hide it from that
dialog. (not sure if this applies to Outlook)

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Can you give me an example of a Public wrapper subroutine?


Jake Marx wrote:
> Hi sapphire,
>
> sapphire wrote:
> > I need to add a button to my outlook toolbar called "send and file".
> > This button needs to call a subroutine that will send the message and
> > allow a user to choose a folder to save the message to (other than the
> > sent items). My subroutine is working correctly. However, I am
> > unable to link it to the toolbar because it is a private subroutine.
> > How can I trigger a private subroutine from a toolbar button?
>
> I assume you're talking about Outlook VBA, not Excel. Regardless, there's
> no way to call a Private subroutine from any location other than the module
> itself. So you'd either need a Public wrapper subroutine, or you'll need to
> make your routine Public. What's the reason for making it Private? If it's
> to keep users from seeing it in a run macros dialog, you can use Option
> Private Module at the top of the code module, which will hide it from that
> dialog. (not sure if this applies to Outlook)
>
> --
> Regards,
>
> Jake Marx
> www.longhead.com
>
>
> [please keep replies in the newsgroup - email address unmonitored]

Can you give me an example of a Public wrapper subroutine?

Thanks much.


Jake Marx wrote:
> Hi sapphire,
>
> sapphire wrote:
> > I need to add a button to my outlook toolbar called "send and file".
> > This button needs to call a subroutine that will send the message and
> > allow a user to choose a folder to save the message to (other than the
> > sent items). My subroutine is working correctly. However, I am
> > unable to link it to the toolbar because it is a private subroutine.
> > How can I trigger a private subroutine from a toolbar button?
>
> I assume you're talking about Outlook VBA, not Excel. Regardless, there's
> no way to call a Private subroutine from any location other than the module
> itself. So you'd either need a Public wrapper subroutine, or you'll need to
> make your routine Public. What's the reason for making it Private? If it's
> to keep users from seeing it in a run macros dialog, you can use Option
> Private Module at the top of the code module, which will hide it from that
> dialog. (not sure if this applies to Outlook)
>
> --
> Regards,
>
> Jake Marx
> www.longhead.com
>
>
> [please keep replies in the newsgroup - email address unmonitored]

sapphire wrote:
> Can you give me an example of a Public wrapper subroutine?
>
> Thanks much.

All I was talking about was creating a Public subroutine that in turn called
the Private one (from the same Module of course).

Public Sub MyWrapper()
DoMyStuff True
End Sub

Private Sub DoMyStuff(dummyVar As Boolean)
'/ your code here
End Sub

But why are is your subroutine Private in the first place if you want it to
be globally callable?

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

It's private because when I type, for example:
Public Sub MyWrapper() and I include something in the () - (var as
Boolean), it automatically makes it a private sub.

Thanks.

Jake Marx wrote:
> sapphire wrote:
> > Can you give me an example of a Public wrapper subroutine?
> >
> > Thanks much.
>
> All I was talking about was creating a Public subroutine that in turn called
> the Private one (from the same Module of course).
>
> Public Sub MyWrapper()
> DoMyStuff True
> End Sub
>
> Private Sub DoMyStuff(dummyVar As Boolean)
> '/ your code here
> End Sub
>
> But why are is your subroutine Private in the first place if you want it to
> be globally callable?
>
> --
> Regards,
>
> Jake Marx
> www.longhead.com
>
>
> [please keep replies in the newsgroup - email address unmonitored]