Distributing Macros/Templates to a large Organization

[BobZ]

I'm new to macros and VB, and I've create a Word doc with some embedded
control buttons that hide/unhide parts of the doc. This is a form for people
in our company to fill out and email back to us. I've been reading about how
to distribute this doc and its macros (and the .dot file perhaps?), but I
don't understand.

Q--How can I send this document out to the company so the controls will
work? We can't/don't use servers to house global templates or run auto
install wizards, etc. Is there a simple way to send this doc out, and how do
I get around the security setting that disable macros?

Thanks in advance!

 

[Perry]

Below I´ve listed a couple of sites that can help you.

My main advise however would be:
Get a good picture of how the network of this "large" organization looks
like.
Ideally, this would come down to get to know the network (Active Directory)
design and how this relates
to the Organigram of the organization.
This way, you will see how organisational units/divisions/business
units/departments/subdepartments are nested and represented in Active
Directory/the network.
Then you can start thinking about a the scope of the macro's, how they need
to "land" in the network
and target the correct usergroups ...

I've seen a lot obsolete scripting come by because a lot of developers who
weren't aware of
Active Directory FRS (File Replication Service). If you don't know what that
is, step up to your
IT department and ask what this does, and how it's scheduled/set up to
schedule.

Here are the URL's

http://word.mvps.org/faqs/macrosvba/DistributeMacros.htm
http://www.microsoft.com/technet/scriptcenter/topics/office/manage/wordfl.mspx

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

 

[BobZ]

Perry--by your answer either I'm way over my head and this is complex, or I
mistated my issue. Do you mean to say that if I want to send out a Word doc
with these control buttons and macros in them that I have to go this route
you suggest? What about just writing instructions to the users on the
download site that if they want to use this doc they have to enable the
macros if they're asked, and/or makesure their Word macro security is set to
medium or lower? (Can you tell which option I'm pulling for? ;-)

--Bob

 

[Perry]

Oh, we're talking one document or template only?

with these control buttons and macros in them that I have to go this route
you suggest?

No! Don't! hahaha

Then, have you looked at this (previously forwarded)

http://word.mvps.org/faqs/macrosvba/DistributeMacros.htm

and a couple of other ones
http://word.mvps.org/mac/installtemplate.html
http://word.mvps.org/faqs/customization/WhatTemplatesStore.htm

Good luck.


--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

 

[Jonathan West]

I'm new to macros and VB, and I've create a Word doc with some embedded
control buttons that hide/unhide parts of the doc. This is a form for
people
in our company to fill out and email back to us. I've been reading about
how
to distribute this doc and its macros (and the .dot file perhaps?), but I
don't understand.

Q--How can I send this document out to the company so the controls will
work? We can't/don't use servers to house global templates or run auto
install wizards, etc. Is there a simple way to send this doc out, and how
do
I get around the security setting that disable macros?

Thanks in advance!

You can make a start by having a look here

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

If you get stuck, ask back here

 

[BobZ]

Thanks guys. Your page to showed me helps me understand, although I'm not
sure I"m going to get the time of our IT dept. to do this for our one doc.
I'll look into it. It does tell me that it's no quick and simple task.

Thanks for the speedy input!