Creating Excel Addin

[salooha]

Hi there,
I am working with excel 2k and xp, I created a workbook that has all the macros that I use and I am trying to create it as an Addin.

I saved the workbook with a .xla under c:\documents and settings\username\application data\microsoft\addins but still it doesn't work as an addin...

I go to tools --> addins --> then browse to the location of the file and I added and make sure it is checked but when I open excel and go to macros, i don't see any of the macros....even with the addin checked.

i would like to be able to click on the .xla workbook and it add itself to excel or at least when I add it by goint to tools --> addins and check it, it would be available throughout excel everytime I open it...

I know that I could save the workbook in XLstart to be available everytime I open excel but I don't like this feature plus I would like to be able to pass on the xla file to other people to install on their machine.....

I checked microsoft website for creating an excel addin and I followed the steps but it still doesn't work.....

any help please is highly appreciated....

you can also email me at leitek@gmail.com

thanks a lot

[Anne Troy]

What are the names of your macros? Can't be private...
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"salooha" <salooha.1qzvmh_1119388040.4973@excelforum-nospam.com> wrote in
message news:salooha.1qzvmh_1119388040.4973@excelforum-nospam.com...
>
> Hi there,
> I am working with excel 2k and xp, I created a workbook that has all
> the macros that I use and I am trying to create it as an Addin.
>
> I saved the workbook with a .xla under c:\documents and
> settings\username\application data\microsoft\addins but still it
> doesn't work as an addin...
>
> I go to tools --> addins --> then browse to the location of the file
> and I added and make sure it is checked but when I open excel and go to
> macros, i don't see any of the macros....even with the addin checked.
>
> i would like to be able to click on the .xla workbook and it add itself
> to excel or at least when I add it by goint to tools --> addins and
> check it, it would be available throughout excel everytime I open
> it...
>
> I know that I could save the workbook in XLstart to be available
> everytime I open excel but I don't like this feature plus I would like
> to be able to pass on the xla file to other people to install on their
> machine.....
>
> I checked microsoft website for creating an excel addin and I followed
> the steps but it still doesn't work.....
>
> any help please is highly appreciated....
>
> you can also email me at leitek@gmail.com
>
> thanks a lot
>
>
> --
> salooha
> ------------------------------------------------------------------------
> salooha's Profile:
http://www.excelforum.com/member.php...o&userid=14612
> View this thread: http://www.excelforum.com/showthread...hreadid=381021
>

[Bob Phillips]

Make sure that

- they are nor Private subs (Private Sub myMacro())
- the code module in the add-in doesn't have Option Private Module at the
start
- the subs and/or functions do not have arguments




RP
(remove nothere from the email address if mailing direct)


"salooha" <salooha.1qzvmh_1119388040.4973@excelforum-nospam.com> wrote in
message news:salooha.1qzvmh_1119388040.4973@excelforum-nospam.com...
>
> Hi there,
> I am working with excel 2k and xp, I created a workbook that has all
> the macros that I use and I am trying to create it as an Addin.
>
> I saved the workbook with a .xla under c:\documents and
> settings\username\application data\microsoft\addins but still it
> doesn't work as an addin...
>
> I go to tools --> addins --> then browse to the location of the file
> and I added and make sure it is checked but when I open excel and go to
> macros, i don't see any of the macros....even with the addin checked.
>
> i would like to be able to click on the .xla workbook and it add itself
> to excel or at least when I add it by goint to tools --> addins and
> check it, it would be available throughout excel everytime I open
> it...
>
> I know that I could save the workbook in XLstart to be available
> everytime I open excel but I don't like this feature plus I would like
> to be able to pass on the xla file to other people to install on their
> machine.....
>
> I checked microsoft website for creating an excel addin and I followed
> the steps but it still doesn't work.....
>
> any help please is highly appreciated....
>
> you can also email me at leitek@gmail.com
>
> thanks a lot
>
>
> --
> salooha
> ------------------------------------------------------------------------
> salooha's Profile:
http://www.excelforum.com/member.php...o&userid=14612
> View this thread: http://www.excelforum.com/showthread...hreadid=381021
>

[Dave Peterson]

If you saved your workbook as an addin, the macros won't be visible via the
Tools|Macro|macros dialog.

You have to give the user a way to get to them.

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the worksheet menubar.

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

salooha wrote:
>
> Hi there,
> I am working with excel 2k and xp, I created a workbook that has all
> the macros that I use and I am trying to create it as an Addin.
>
> I saved the workbook with a .xla under c:\documents and
> settings\username\application data\microsoft\addins but still it
> doesn't work as an addin...
>
> I go to tools --> addins --> then browse to the location of the file
> and I added and make sure it is checked but when I open excel and go to
> macros, i don't see any of the macros....even with the addin checked.
>
> i would like to be able to click on the .xla workbook and it add itself
> to excel or at least when I add it by goint to tools --> addins and
> check it, it would be available throughout excel everytime I open
> it...
>
> I know that I could save the workbook in XLstart to be available
> everytime I open excel but I don't like this feature plus I would like
> to be able to pass on the xla file to other people to install on their
> machine.....
>
> I checked microsoft website for creating an excel addin and I followed
> the steps but it still doesn't work.....
>
> any help please is highly appreciated....
>
> you can also email me at leitek@gmail.com
>
> thanks a lot
>
> --
> salooha
> ------------------------------------------------------------------------
> salooha's Profile: http://www.excelforum.com/member.php...o&userid=14612
> View this thread: http://www.excelforum.com/showthread...hreadid=381021

--

Dave Peterson

[salooha]

Thank you for your help....let's say I have the code below to open a notepad from excel....and I would like to have this available throughout excel as an addin that can be installed on any machine that has excel....the code below is not private as far as I know.....and I have no functions involved...

Please Login or Register  to view this content.

can I create an addin that could be available whenever I open excel and could be transfered on other machines as well?? I hope I clarified my question this time a little.....

thanks again for your help....

salah

[Dave Peterson]

Take a look at John Walkenbach's menumaker workbook.

You'll see how he does it.

salooha wrote:
>
> Thank you for your help....let's say I have the code below to open a
> notepad from excel....and I would like to have this available
> throughout excel as an addin that can be installed on any machine that
> has excel....the code below is not private as far as I know.....and I
> have no functions involved...
>
> Code:
> --------------------
>
> ' Open Notepad
> Sub OpenNotepad()
> Dim retval As Variant
> retval = Shell("C:\WINNT\system32\notepad.exe", vbNormalFocus)
> Shell "notepad c:\myfile.txt"
> End Sub
>
> --------------------
>
>
> can I create an addin that could be available whenever I open excel and
> could be transfered on other machines as well?? I hope I clarified my
> question this time a little.....
>
> thanks again for your help....
>
> salah
>
> --
> salooha
> ------------------------------------------------------------------------
> salooha's Profile: http://www.excelforum.com/member.php...o&userid=14612
> View this thread: http://www.excelforum.com/showthread...hreadid=381021

--

Dave Peterson

[salooha]

Thanks Dave..