PC Review


Reply
Thread Tools Rate Thread

click a button on the toolbar (via VBA?)

 
 
Dan
Guest
Posts: n/a
 
      28th Apr 2006
hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send SMS
trhough my local provider. Unfortunately, there is no programmatic (library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook contacts), a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate a
send from there.

is there a way to use VBA to click on a button in the toolbar that does not
expose itself in the library?

thanks

dan


 
Reply With Quote
 
 
 
 
Michael Bauer
Guest
Posts: n/a
 
      30th Apr 2006
Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a reference
on that button. For a CommandBarButton you can then call its Execute method,
thatīs similar to a click on that button. But thatīs it. You still need to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


> hi there,
>
> I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
> 2003. That plugin adds a button to the toolbar which allows me to send SMS
> trhough my local provider. Unfortunately, there is no programmatic

(library)
> access to that plugin. The functionality is very primitive. I click the
> button and a form opens that allows me to enter a name for the receiver
> (that one will be checked against the directory or the Outlook contacts),

a
> text to be sent and that's about it.
>
> There is no way I can see to fire up that form except to click on that
> button. I wonder if there might be a way to add some more functionality,
> like adding that tool to the right click menu of a contact and initiate a
> send from there.
>
> is there a way to use VBA to click on a button in the toolbar that does

not
> expose itself in the library?
>
> thanks
>
> dan

 
Reply With Quote
 
Dan
Guest
Posts: n/a
 
      1st May 2006
I investigated a little more and found a similar thing on Sue's website at
http://www.outlookcode.com/codedetail.aspx?id=350. I made some changes and
the result is below. However, it does not work. apparently I do something
wrong. the ID as from OutlookSpy is 1, but is 1 for all external COM
add-ins. so I thought I'd would try the statement below..

any idea why there is no ID to be found?


Sub ToggleSMS()
Dim objOL As Outlook.Application
Dim objExpl As Outlook.Explorer
Dim objCBB As Office.CommandBarButton
On Error Resume Next

Set objOL = CreateObject("Outlook.Application")
Set objExpl = objOL.ActiveExplorer
Set objCBB = objExpl.CommandBars.FindControl(, ID:= _
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS").ID)
objCBB.Execute

Set objOL = Nothing
Set objExpl = Nothing
Set objCBB = Nothing
End Sub


"Dan" <(E-Mail Removed)> wrote in message
news:u%(E-Mail Removed)...
> Thanks a lot for that pointer, Michael.
>
> I found the button with OutlookSpy:
> CommandBars.Item("Desktop SMS").Controls.Item("New S&MS")
>
> could you eventually point me to a description on how to do that execute
> method? I am not quite a specialist on programming.
>
> thanks a lot
>
> dan
>
>
> "Michael Bauer" <(E-Mail Removed)> wrote in message
> news:1wype4qocq3jl.8ij5mj04fnng$.(E-Mail Removed)...
>> Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:
>>
>> Dan, you could use the CommandBars.FindControl function to get a
>> reference
>> on that button. For a CommandBarButton you can then call its Execute
>> method,
>> thatīs similar to a click on that button. But thatīs it. You still need
>> to
>> do a click somewhere and then enter more information, so I donīt see any
>> advantage.
>>
>> --
>> Viele Gruesse / Best regards
>> Michael Bauer - MVP Outlook
>> -- www.vbOffice.net --
>>
>>
>>> hi there,
>>>
>>> I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
>>> 2003. That plugin adds a button to the toolbar which allows me to send
>>> SMS
>>> trhough my local provider. Unfortunately, there is no programmatic

>> (library)
>>> access to that plugin. The functionality is very primitive. I click the
>>> button and a form opens that allows me to enter a name for the receiver
>>> (that one will be checked against the directory or the Outlook
>>> contacts),

>> a
>>> text to be sent and that's about it.
>>>
>>> There is no way I can see to fire up that form except to click on that
>>> button. I wonder if there might be a way to add some more functionality,
>>> like adding that tool to the right click menu of a contact and initiate
>>> a
>>> send from there.
>>>
>>> is there a way to use VBA to click on a button in the toolbar that does

>> not
>>> expose itself in the library?
>>>
>>> thanks
>>>
>>> dan

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
reset ALL checkboxes (created with control toolbar) with the click of ONE BUTTON kpeschel@earthlink.net Microsoft Excel Programming 1 7th Jul 2007 07:27 PM
Creat Single-Click Toolbar Button to Mark Spam =?Utf-8?B?U2hyb29tQ2hlZg==?= Microsoft Outlook Discussion 0 16th Oct 2006 10:28 PM
How to fire both event button click and textchanged when button is click and text is changed Amy Microsoft ASP .NET 0 1st Jun 2006 03:33 PM
click a button on the toolbar (via VBA?) Dan Microsoft Outlook VBA Programming 7 2nd May 2006 09:35 AM
on click event for item on a dropdown button control on toolbar Curtis Microsoft VB .NET 1 15th Oct 2004 09:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:13 PM.