How to put excel macros in a 'global' place.
 

Hi,

I wrote some excel macros that need to be stored in a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that in the addin list, but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--

How to put excel macros in a 'global' place.
 

An addin can be made to work if you learn all the necessary steps. I don't
know them off the top of my head, but the easiest thing to do is put them in
your Personal.xls workbook

"Peter van de Kerkhof" wrote in message
...
Hi,

I wrote some excel macros that need to be stored in a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that in the addin list,
but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--

How to put excel macros in a 'global' place.
 

Run "Bookname.xla!MacroName"
for macros located outside a project.

Or set a reference to the xla workbook in the other book's Tools -
References in the vbe. Then the macro is callable as if it were in that
project.


"Peter van de Kerkhof" wrote in message
...
Hi,

I wrote some excel macros that need to be stored in a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that in the addin list,
but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--

How to put excel macros in a 'global' place.
 

Tim,

This doesn't seem to work for me.

Created the xla put is in the addin list
but macro no 'visible'
Even: Run "Bookname.xla!MacroName" didn't work

Putting the 'lib.xls" file in XLstart folder of msoffice doesn't do the
trick.
(it loads the file, but no macro visible!)

Loading: set reference to xla in vbe doesn't work, because it tries to load
it twice




"Tim Zych" schreef in bericht
...
Run "Bookname.xla!MacroName"
for macros located outside a project.

Or set a reference to the xla workbook in the other book's Tools -
References in the vbe. Then the macro is callable as if it were in that
project.


"Peter van de Kerkhof" wrote in message
...
Hi,

I wrote some excel macros that need to be stored in a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that in the addin list,
but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--

How to put excel macros in a 'global' place.
 

Created the xla put is in the addin list
but macro no 'visible'

That's right. It will not be visible in the macro dialog,
but it is available to run.

For sure the approach works. The addin must be loaded.
What is the name of the addin and the macro name?

-----Original Message-----
Tim,

This doesn't seem to work for me.

Created the xla put is in the addin list
but macro no 'visible'
Even: Run "Bookname.xla!MacroName" didn't work

Putting the 'lib.xls" file in XLstart folder of msoffice
doesn't do the
trick.
(it loads the file, but no macro visible!)

Loading: set reference to xla in vbe doesn't work,
because it tries to load
it twice




"Tim Zych" schreef in bericht
...
Run "Bookname.xla!MacroName"
for macros located outside a project.

Or set a reference to the xla workbook in the other
book's Tools -
References in the vbe. Then the macro is callable as if
it were in that
project.


"Peter van de Kerkhof" wrote in
message
...
Hi,

I wrote some excel macros that need to be stored in
a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that
in the addin list,
but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--






.