I have created an addin from a sub() that I wrote in vba.

Now I want to create a button that runs the sub.

What must I put in the macro run box?

Addin name : addin
Project name : project
sub name : work()

Thanks

Roger,

Immediate way

Application.Run "Work"

Better way,

set a reference to the addin in Tools>References, and then just call it like
any other sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Roger" <(E-Mail Removed)> wrote in message
news:09e801c3a126$1d402c80$(E-Mail Removed)...
> I have created an addin from a sub() that I wrote in vba.
>
> Now I want to create a button that runs the sub.
>
> What must I put in the macro run box?
>
> Addin name : addin
> Project name : project
> sub name : work()
>
> Thanks

Hmm

I want to make it so that the user can run the program at
any time, from any workbook. As they get a dump from
another program and this will sort it out into how they
want it.

Maybe I just misunderstood what you said.. could you
re-word it please then

Thanks

>-----Original Message-----
>Roger,
>
>Immediate way
>
>Application.Run "Work"
>
>Better way,
>
>set a reference to the addin in Tools>References, and then
just call it like
>any other sub.
>
>--
>
>HTH
>
>Bob Phillips
> ... looking out across Poole Harbour to the Purbecks
>(remove nothere from the email address if mailing direct)
>
>"Roger" <(E-Mail Removed)> wrote in message
>news:09e801c3a126$1d402c80$(E-Mail Removed)...
>> I have created an addin from a sub() that I wrote in
vba.
>>
>> Now I want to create a button that runs the sub.
>>
>> What must I put in the macro run box?
>>
>> Addin name : addin
>> Project name : project
>> sub name : work()
>>
>> Thanks
>
>
>.
>

Roger,

As it is an addin, you will need to install it on each machine that you want
to run from, agreed? I also assume that you don't want to set a reference to
the addin in each workbook, so the immediate way is best.

That being so, I assume you know how to create a button and add a macro call
from there. Let's assume that the button macro is called "RogersSub".

The code for "RogersSub" would look something akin to

Sub RogersSub()
Application.Run "Work"
End Sub

That should do it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Roger" <(E-Mail Removed)> wrote in message
news:02e901c3a130$d3a2f480$(E-Mail Removed)...
> Hmm
>
> I want to make it so that the user can run the program at
> any time, from any workbook. As they get a dump from
> another program and this will sort it out into how they
> want it.
>
> Maybe I just misunderstood what you said.. could you
> re-word it please then
>
> Thanks
>
> >-----Original Message-----
> >Roger,
> >
> >Immediate way
> >
> >Application.Run "Work"
> >
> >Better way,
> >
> >set a reference to the addin in Tools>References, and then
> just call it like
> >any other sub.
> >
> >--
> >
> >HTH
> >
> >Bob Phillips
> > ... looking out across Poole Harbour to the Purbecks
> >(remove nothere from the email address if mailing direct)
> >
> >"Roger" <(E-Mail Removed)> wrote in message
> >news:09e801c3a126$1d402c80$(E-Mail Removed)...
> >> I have created an addin from a sub() that I wrote in
> vba.
> >>
> >> Now I want to create a button that runs the sub.
> >>
> >> What must I put in the macro run box?
> >>
> >> Addin name : addin
> >> Project name : project
> >> sub name : work()
> >>
> >> Thanks
> >
> >
> >.
> >

As an addendum to Bob's comment, you can reference the add-
in as follows

Application.Run "addin.xla!Work"

Kevin Beckham

>-----Original Message-----
>Roger,
>
>As it is an addin, you will need to install it on each
machine that you want
>to run from, agreed? I also assume that you don't want to
set a reference to
>the addin in each workbook, so the immediate way is best.
>
>That being so, I assume you know how to create a button
and add a macro call
>from there. Let's assume that the button macro is
called "RogersSub".
>
>The code for "RogersSub" would look something akin to
>
>Sub RogersSub()
> Application.Run "Work"
>End Sub
>
>That should do it.
>
>--
>
>HTH
>
>Bob Phillips
> ... looking out across Poole Harbour to the Purbecks
>(remove nothere from the email address if mailing direct)
>
>"Roger" <(E-Mail Removed)> wrote in message
>news:02e901c3a130$d3a2f480$(E-Mail Removed)...
>> Hmm
>>
>> I want to make it so that the user can run the program
at
>> any time, from any workbook. As they get a dump from
>> another program and this will sort it out into how they
>> want it.
>>
>> Maybe I just misunderstood what you said.. could you
>> re-word it please then
>>
>> Thanks
>>
>> >-----Original Message-----
>> >Roger,
>> >
>> >Immediate way
>> >
>> >Application.Run "Work"
>> >
>> >Better way,
>> >
>> >set a reference to the addin in Tools>References, and
then
>> just call it like
>> >any other sub.
>> >
>> >--
>> >
>> >HTH
>> >
>> >Bob Phillips
>> > ... looking out across Poole Harbour to the
Purbecks
>> >(remove nothere from the email address if mailing
direct)
>> >
>> >"Roger" <(E-Mail Removed)> wrote in message
>> >news:09e801c3a126$1d402c80$(E-Mail Removed)...
>> >> I have created an addin from a sub() that I wrote in
>> vba.
>> >>
>> >> Now I want to create a button that runs the sub.
>> >>
>> >> What must I put in the macro run box?
>> >>
>> >> Addin name : addin
>> >> Project name : project
>> >> sub name : work()
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>