Prev: xlFillDefault, based on values in ColA to ColZ
Next: Data aggregation with multiple workbooks
From: GS on 10 May 2010 17:23
Hi Bob,

Very nice article! Well done! Props to you...
So nice that I think I might actually try it with my next
workbook-based addin for MSO12+ clients.

I thought about doing similar to this before I decided to make all my
apps COMAddins, but I couldn't resolve the lack of security that tags
along with it. I now do the same thing via code as outlined in Excel
2007 VBA Programmer's Reference. It simply checks version of the host
app to determine what to do. Since my addins are task-specific, I only
use an automated instance where I hide everything except the tab with
my menus. This would be the built-in Addins tab because my menus are
all that's there, AND I still use Rob's table-driven CommandbarBuilder
wrapper for creating custom menus/toolbars as a matter of convenience.
That's about the only code in the xla I open, except for the sub that
passes the entry point parameters to the COMAddin. It's also a single
proc used by all menus, which passes their OnAction via the Tag prop
and any parameters as a delimited string via the Parameter prop.

Lots of similarities but not as easy as the old days, huh!

Regards,
Garry


From: Bob Phillips on 10 May 2010 17:39

"Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message
news:uODR9sG8KHA.5808(a)TK2MSFTNGP02.phx.gbl...

> You shared that info to another post. So I figured I'd just add it into
> one of my "saved from a previous post" replies.


That is what I mean, you see everything. I think there are lots of you in
reality, Dave Peterson is really a franchise <ebg>


From: Dave Peterson on 10 May 2010 17:43
Or just retired with nothing better to do!



Bob Phillips wrote:

> "Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message
> news:uODR9sG8KHA.5808(a)TK2MSFTNGP02.phx.gbl...
>
>
>>You shared that info to another post. So I figured I'd just add it into
>>one of my "saved from a previous post" replies.
>
>
>
> That is what I mean, you see everything. I think there are lots of you in
> reality, Dave Peterson is really a franchise <ebg>
>
>

--

Dave Peterson
From: Dave Peterson on 10 May 2010 17:52
This was supposed to be a reply to Bob.

Dave Peterson wrote:

> Or just retired with nothing better to do!
>
>
>
> Bob Phillips wrote:
>
>> "Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message
>> news:uODR9sG8KHA.5808(a)TK2MSFTNGP02.phx.gbl...
>>
>>
>>> You shared that info to another post. So I figured I'd just add it
>>> into one of my "saved from a previous post" replies.
>>
>>
>>
>>
>> That is what I mean, you see everything. I think there are lots of you
>> in reality, Dave Peterson is really a franchise <ebg>
>>
>

--

Dave Peterson
From: Dave Peterson on 10 May 2010 17:57
Hmmm.

The headers must have gotten confused in my newsreader. Now my response to Bob
shows up as a response to Bob. But my response to my response is under GS's
message.

Hmmm.

Dave Peterson wrote:

> This was supposed to be a reply to Bob.
>
> Dave Peterson wrote:
>
>> Or just retired with nothing better to do!
>>
>>
>>
>> Bob Phillips wrote:
>>
>>> "Dave Peterson" <petersod(a)XSPAMverizon.net> wrote in message
>>> news:uODR9sG8KHA.5808(a)TK2MSFTNGP02.phx.gbl...
>>>
>>>
>>>> You shared that info to another post. So I figured I'd just add it
>>>> into one of my "saved from a previous post" replies.
>>>
>>>
>>>
>>>
>>>
>>> That is what I mean, you see everything. I think there are lots of
>>> you in reality, Dave Peterson is really a franchise <ebg>
>>>
>>
>

--

Dave Peterson
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: xlFillDefault, based on values in ColA to ColZ
Next: Data aggregation with multiple workbooks