LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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









 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i use my computer to make a map of my library for student mrs. bookheart Excel Discussion (Misc queries) 2 July 27th 09 07:25 PM
Run worksheet module code from workbook module? keithb Excel Programming 1 August 14th 05 04:04 AM
Excel XP: How to make a reference to a library persistent Marcel[_4_] Excel Programming 2 December 11th 04 08:27 PM
Reference Library - Missing Library in a lower version. luvgreen Excel Programming 1 October 7th 04 02:08 AM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"