SHARING MACROS VIA ADD-IN (.xla) FILE
 

We are using Excel 2002, SP-2 on a network. We have a workbook fil
containing macros saved as an .xla file on a shared drive. Exce
insists on having its .xla files stored in the C:\Documents an
Settings\network ID\Application Data\Microsoft\AddIns folder; however
if the appropriate .xla file is merely saved to that folder, that wil
NOT work. One must select ToolsAdd-InsBrowse and then select th
same .xla file stored elsewhere and then Excel copies it to the abov
folder.

The only concern about the above is when updating the network .xla fil
and having each user go thru the TAB sequence.

But that's only part of the problem: even when the .xla file is save
appropriately, I am having difficulty assigning macros to individua
Custom Buttons I created on the Standard Toolbar. There is a stron
inclination by Excel to put the name of the host workbook (even a blan
Book1) as a prefix to the name of the macro that is supposed to appea
in the linkage window.

Also, now when going thru the TAB sequence and using the share
drive version, I get the error message: ....xla is not a valid add-in
Is it necessary to delete the local version of the .xla file first?

Lastly, on one workstation (mine), I was able to assign macros t
Custom Buttons.
However, I get a message that Excel cannot find the macro. I mus
first go thru the TAB sequence using the local version of the .xl
file (I made this sequence part of the primary macro).

One complicating issue: the workbook that these macros are designe
for is not opened by the user; it is created by another softwar
product that has Excel workbook creation as one of its custom repor
options. This is where the Custom Buttons come into play.

HELP!
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26701

SHARING MACROS VIA ADD-IN (.xla) FILE
 

Hi chuckles,

Excel does not insist on addins being in its Addins folder, it just asks you
if you want to copy them there. My recommended response is NO.

As an alternative you may want to look at the automatic Reversioning addin
loader on the downloads page at
http://www.decisionModels.com/downloads.htm

This solves many of the problems associated with runiing and updating addins
from a shared server (but probably not all of them!)

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com


"Chuckles123" wrote in message
...

We are using Excel 2002, SP-2 on a network. We have a workbook file
containing macros saved as an .xla file on a shared drive. Excel
insists on having its .xla files stored in the C:\Documents and
Settings\network ID\Application Data\Microsoft\AddIns folder; however,
if the appropriate .xla file is merely saved to that folder, that will
NOT work. One must select ToolsAdd-InsBrowse and then select the
same .xla file stored elsewhere and then Excel copies it to the above
folder.

The only concern about the above is when updating the network .xla file
and having each user go thru the TAB sequence.

But that's only part of the problem: even when the .xla file is saved
appropriately, I am having difficulty assigning macros to individual
Custom Buttons I created on the Standard Toolbar. There is a strong
inclination by Excel to put the name of the host workbook (even a blank
Book1) as a prefix to the name of the macro that is supposed to appear
in the linkage window.

Also, now when going thru the TAB sequence and using the shared
drive version, I get the error message: ....xla is not a valid add-in.
Is it necessary to delete the local version of the .xla file first?

Lastly, on one workstation (mine), I was able to assign macros to
Custom Buttons.
However, I get a message that Excel cannot find the macro. I must
first go thru the TAB sequence using the local version of the .xla
file (I made this sequence part of the primary macro).

One complicating issue: the workbook that these macros are designed
for is not opened by the user; it is created by another software
product that has Excel workbook creation as one of its custom report
options. This is where the Custom Buttons come into play.

HELP!
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=267013