Hello,
I created an addin for excel, work find when in the spreadsheet... but now I
want to be able to call my functions from within VBA? The addin is loaded?
How can I do this?
Thanks,
Brian

--
Please remove the 123 from the EMAIL Address. This has been added to prevent
spamming.


pssssst! Here spammer, spammer, spammer.
(E-Mail Removed), (E-Mail Removed), (E-Mail Removed), (E-Mail Removed)

Hi Brian!

If you set a reference to it you can call it just like the function is
in the subject workbook.

Tools > References
Check against your Addin.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(E-Mail Removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Brian Shafer" <(E-Mail Removed)> wrote in message
news:wFqKb.138945$VB2.521485@attbi_s51...
> Hello,
> I created an addin for excel, work find when in the spreadsheet...
but now I
> want to be able to call my functions from within VBA? The addin is
loaded?
> How can I do this?
> Thanks,
> Brian
>
> --
> Please remove the 123 from the EMAIL Address. This has been added to
prevent
> spamming.
>
>
> pssssst! Here spammer, spammer, spammer.
> (E-Mail Removed), (E-Mail Removed), (E-Mail Removed),
(E-Mail Removed)
>
>
>

Just to add to Norman's post:

that Reference is under the Tools menu in the VBE (not excel itself).

And you'll want to change the name of the XLA's project (from the default
VBAProject).

While in the VBE, hit ctrl-R to show the project explorer. Then click on the
VBAProject (YourAddinName.XLA)

and hit F4 and rename the project in the (Name) box.

===
An alternative that you could use without setting a reference is to use
application.run.

Option Explicit
Sub testme()
Dim tempLong As Long
tempLong = Application.Run("personal.xla!myfunction", Range("a1:a10"))
End Sub

would be one example



Norman Harker wrote:
>
> Hi Brian!
>
> If you set a reference to it you can call it just like the function is
> in the subject workbook.
>
> Tools > References
> Check against your Addin.
> --
> Regards
> Norman Harker MVP (Excel)
> Sydney, Australia
> (E-Mail Removed)
> Excel and Word Function Lists (Classifications, Syntax and Arguments)
> available free to good homes.
> "Brian Shafer" <(E-Mail Removed)> wrote in message
> news:wFqKb.138945$VB2.521485@attbi_s51...
> > Hello,
> > I created an addin for excel, work find when in the spreadsheet...
> but now I
> > want to be able to call my functions from within VBA? The addin is
> loaded?
> > How can I do this?
> > Thanks,
> > Brian
> >
> > --
> > Please remove the 123 from the EMAIL Address. This has been added to
> prevent
> > spamming.
> >
> >
> > pssssst! Here spammer, spammer, spammer.
> > (E-Mail Removed), (E-Mail Removed), (E-Mail Removed),
> (E-Mail Removed)
> >
> >
> >

--

Dave Peterson
(E-Mail Removed)