We need to overwrite corrupted MS Word macros with good code (we
already have the good code).  These .bas files interact with MS Word
by executing format-standardizing keystrokes into a .dot file. 
Unfortunately the .bas code on each workstation is unstable and has
been corrupted, so we need to re-install these macros.  Problem is
that cutting and pasting code into Word's 'record macro' feature
records the copy/paste keystrokes, not the executable VB commands.

How and where do we overwrite the corrupted .bas file with the good
code?  As mentioned above, we have the good VB code but can't find the
location in MS Word's architecture for re-installing it.  Originally
these files were set up for 'drag-and-drop' update capability on our
Exchange server, but we'd be willing to simply re-install the good
code on each machine if possible.

Thanks.

---

Request for Question Clarification by maniac-ga on 07 Aug 2005 21:07 PDT

Hello Asapbob,

I am a little uncertain about the Exchange server connection as well,
but you should be able to do something like the following:

Open a word file.
Use the menu item
  Tools -> Macros -> Visual Basic Editor
at this point, Visual Basic will start. Hopefully it will show a
window with your macros in it. On my system, I get a window labeled
  "Normal - New Macros (code)"
where I can see the macros I have on my system (stored in the Normal
template file) but on your systems, this is not necessarily the case.
If the module window is shown, you can then copy / paste the new
macros over the old ones. Use the menu
  File -> Save Normal
  File -> Close and Return to Microsoft Word
to save the changes / get back to word.

If not, you will have to do something more to get to the old
(corrupted) macros. One method that "always works" for me is the
following sequence.
  Tools -> Macro -> Macros
select one of the corrupt macros and then Step
at this point Visual Basic should run and the first part of the
corrupt macro will be displayed. Use menu
  Run -> Reset
to stop execution and then copy / paste, save, and return to word as
described above.

Let me know if this does the job for you so I can post a complete
answer. If not, describe the problems you have so I can correct the
information provided.

  --Maniac

Well, now I can't figure out what Exchange Server has to do with this
at all, unless you sent them a file they opened with Word and there
were autorun macros in it that copied the BAS.

Why are you not simply creating a global template? Most people don't
mess with the actual BAS files.

Please see this Microsoft article. I will try to check back to see if
you continue to have questions.

http://office.microsoft.com/en-us/assistance/HA010872941033.aspx

~Anne Troy