Macro - autocorrect backup (Office XP Pro)

[Urvasi]

i have created some macros that i would like to share with
the rest of the staff in our office. how do we copy them
from my computer to the others? is the "autocorrect
backup" file in Office 2000? and is this the way to go? i
am not very tech savvy but we have guys in the office who
are so please send any and all info so that we can solve
this dilema. thank you one and all ...

 

[Gord Dibben]

Urvasi

The easieat way to share macros is to place them in a workbook which you then
save as an Add-in.

You can distribute the Add-in to your users.

To save as an Add-in, File>Save As>File Type> MS Excel Add-in(*.xla)

You find this at the bottom of the File Type dialog box list.

Send the add-in to others and they can load it in Tools>Add-ins if they place
it in their Office\Library folder.

If on a network, perhaps place the add-in into a folder which can be accessed
by all users. This would be easiest, since only one copy would be
distributed.

Your question on the Autocorrect list is in connection with the macros, I
assume. This file has nothing to do with macros.

If it is a separate question you can look for *.ACL on your computer.

Note: the *.ACL is common to all Office Applications(Word, Excel, Access)

Gord Dibben Excel MVP

 

[Dave Peterson]

Here's a link that has some code written by Dana DeLouis that will display the
autocorrect list. You can edit it down to merge with another user.

You could even use one of the subroutines to clean up the things you added.

If I added a bunch of words to my own .ACL file, I wouldn't want you to
overwrite my list with yours.

http://groups.google.com/[email protected]