How to make a module library.
 

I have some functions I programmed in a worksheet and i'd like to share them
with my development group. I had already saved it as ".xla" on a common path
that all can access, but when I program new function every body have to "Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the newest
version of the functions from the net ?

thx

How to make a module library.
 

Surely, if they leave it where it is on the shared directory, updating it
overnight will mean they all get the updated version when they start Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to share
them
with my development group. I had already saved it as ".xla" on a common
path
that all can access, but when I program new function every body have to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the newest
version of the functions from the net ?

thx

How to make a module library.
 

Thanks Bob I'll Try it

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory, updating it
overnight will mean they all get the updated version when they start Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to share
them
with my development group. I had already saved it as ".xla" on a common
path
that all can access, but when I program new function every body have to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the newest
version of the functions from the net ?

thx

How to make a module library.
 

Hi Bob

It worked, but when I need to update any function in the ".xla" everyone who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes out of
Excel, or another way to make a library or functions to be used in Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory, updating it
overnight will mean they all get the updated version when they start Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to share
them
with my development group. I had already saved it as ".xla" on a common
path
that all can access, but when I program new function every body have to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the newest
version of the functions from the net ?

thx

How to make a module library.
 

Hi Fabio,

No, you cannot update it if it is open, but that is why I suggested an
overnight update, when they would all be out.

They do not need to exit Excel though, they just need to uncheck the add-in
(ToolsAddins) whilst you update, then re-check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi Bob

It worked, but when I need to update any function in the ".xla" everyone
who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes out
of
Excel, or another way to make a library or functions to be used in Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory, updating
it
overnight will mean they all get the updated version when they start
Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to
share
them
with my development group. I had already saved it as ".xla" on a
common
path
that all can access, but when I program new function every body have
to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the
newest
version of the functions from the net ?

thx

How to make a module library.
 

Hi
It worked as you said.

Is there another way to share my personal function library with my other
programming mates ?



"Bob Phillips" wrote:

Hi Fabio,

No, you cannot update it if it is open, but that is why I suggested an
overnight update, when they would all be out.

They do not need to exit Excel though, they just need to uncheck the add-in
(ToolsAddins) whilst you update, then re-check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi Bob

It worked, but when I need to update any function in the ".xla" everyone
who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes out
of
Excel, or another way to make a library or functions to be used in Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory, updating
it
overnight will mean they all get the updated version when they start
Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to
share
them
with my development group. I had already saved it as ".xla" on a
common
path
that all can access, but when I program new function every body have
to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the
newest
version of the functions from the net ?

thx

How to make a module library.
 

That is the best and simplest way IMO Fabio.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi
It worked as you said.

Is there another way to share my personal function library with my other
programming mates ?



"Bob Phillips" wrote:

Hi Fabio,

No, you cannot update it if it is open, but that is why I suggested an
overnight update, when they would all be out.

They do not need to exit Excel though, they just need to uncheck the
add-in
(ToolsAddins) whilst you update, then re-check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi Bob

It worked, but when I need to update any function in the ".xla"
everyone
who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes
out
of
Excel, or another way to make a library or functions to be used in
Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory,
updating
it
overnight will mean they all get the updated version when they start
Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to
share
them
with my development group. I had already saved it as ".xla" on a
common
path
that all can access, but when I program new function every body
have
to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the
newest
version of the functions from the net ?

thx

How to make a module library.
 

Thanks a Lot.

"Bob Phillips" wrote:

That is the best and simplest way IMO Fabio.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi
It worked as you said.

Is there another way to share my personal function library with my other
programming mates ?



"Bob Phillips" wrote:

Hi Fabio,

No, you cannot update it if it is open, but that is why I suggested an
overnight update, when they would all be out.

They do not need to exit Excel though, they just need to uncheck the
add-in
(ToolsAddins) whilst you update, then re-check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
Hi Bob

It worked, but when I need to update any function in the ".xla"
everyone
who
had "add in" the ".xla" needs to close Excel. Then I can update.

Is there another way to update the my library without every one goes
out
of
Excel, or another way to make a library or functions to be used in
Excel ?

thx

"Bob Phillips" wrote:

Surely, if they leave it where it is on the shared directory,
updating
it
overnight will mean they all get the updated version when they start
Excel
the next day.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fabio" wrote in message
...
I have some functions I programmed in a worksheet and i'd like to
share
them
with my development group. I had already saved it as ".xla" on a
common
path
that all can access, but when I program new function every body
have
to
"Add
ins" again.
Is there a way to refresh the worksheet automaticaly and get the
newest
version of the functions from the net ?

thx