how do i export macros from one computer to another computer?

[Jonathan West]

Distributing macros to other users
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm


What do Templates and Add-ins store?
http://www.word.mvps.org/FAQs/Customization/WhatTemplatesStore.htm

 

[Barry Schwarz]

On Sun, 29 Oct 2006 07:45:02 -0800, Gerob2000

See the "Distributing macros to other users" article at
www.word.mvps.org.


Remove del for email

 

[Lüko Willms]

Am Sun, 29 Oct 2006 15:45:02 UTC, schrieb Gerob2000
<[email protected]> auf
microsoft.public.word.vba.general :

When in the VBA editor, you can simply "Export" individual modules
or forms, and then import these into other documents on the same or
other computers.


Yours,
L.W.

 

[src]

Hi Jonathan,

I've read your great (and easy to understand) arcticle about
distributing macros by setting a login script to copy macros to the
user's machine.

Before we implement this at our company, I've got a question about how
the template is attached:

Assuming that our template with company specific mods is saved to the
user's local drive (c:\Documents and Settings\user\Application
Data\Microsoft\Word\STARTUP), a user opens the template to start a new
doc. When checking Tools > Templates and Addins..., the template
location will point to the user's local drive.

If another user then opens the document for editing, will their
template location still point to the first user's machine, or is there
a way to have it point locally to their machine?

In other words, how can we get Word to look in a consistent location
for templates in a collaborative environment?

Thanks!
Matt

 

[Doug Robbins - Word MVP]

Tools>Options>File Locations

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jonathan West]

Hi Jonathan,

I've read your great (and easy to understand) arcticle about
distributing macros by setting a login script to copy macros to the
user's machine.

Before we implement this at our company, I've got a question about how
the template is attached:

Assuming that our template with company specific mods is saved to the
user's local drive (c:\Documents and Settings\user\Application
Data\Microsoft\Word\STARTUP), a user opens the template to start a new
doc. When checking Tools > Templates and Addins..., the template
location will point to the user's local drive.

If another user then opens the document for editing, will their
template location still point to the first user's machine, or is there
a way to have it point locally to their machine?

In other words, how can we get Word to look in a consistent location
for templates in a collaborative environment?

I think you need to distinguish between a template (on which you can base
documents) and an add-in (which contains macros etc that are generally
available)

Add-ins go in the startup folder. Templates should go in the User Templates
folder, not the Startup folder. The user templates folder by default is
c:\Documents and Settings\<username>\Application Data\Microsoft\Templates.

When you move a document round your organisation, the full path of the
template location is hardcoded into the document. But if the template is not
there when the document is opened by another user, Word will instead look to
see if there is a template of the same name in the User Templates folder. If
there is, it attaches the document to that instead.

So, all you need do is ensure that the templates go in the user templates
folder, and all should be well.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[emman belmes]

See my simple work around steps on exporting macro in ms excel

http://tech-iman.blogspot.com/2011/01/macro-how-to-export-macro-how-to-save.html