Calling a private sub in Outlook via toolbar button

[sapphire]

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!

 

[Jake Marx]

Hi sapphire,

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]

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

Hi sapphire,

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]

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

Thanks much.

Hi sapphire,

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]

 

[Jake Marx]

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]

 

[sapphire]

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.

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]