Distributing macro's

Hello,
I made a few macro's and i wan't to share them with other people. The
macro's are on a server. How can I do this?
Greets,
Jan Willem

Jonathan
Thu Jun 23 04:32:07 CDT 2005


"TiemG" <TiemG@discussions.microsoft.com> wrote in message
news:AAB201D1-05EE-4C67-9EA1-541A04B0D8D1@microsoft.com...
> Hello,
> I made a few macro's and i wan't to share them with other people. The
> macro's are on a server. How can I do this?
> Greets,
> Jan Willem

Take a look at this article

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


--
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

TiemG
Thu Jun 23 08:51:03 CDT 2005

I did that but then I get an error on the following statement:
NormalTemplate.AutoTextEntries("TEXT").Insert Where:= _
Selection.Range, RichText:=True
Has this something to do with the fact that the macro is in the startup
folder? Because when I insert the macro in the User template folder then the
macro does work correctly.

"Jonathan West" wrote:

>
> "TiemG" <TiemG@discussions.microsoft.com> wrote in message
> news:AAB201D1-05EE-4C67-9EA1-541A04B0D8D1@microsoft.com...
> > Hello,
> > I made a few macro's and i wan't to share them with other people. The
> > macro's are on a server. How can I do this?
> > Greets,
> > Jan Willem
>
> Take a look at this article
>
> Distributing macros to other users
> http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm
>
>
> --
> 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
>
>

Charles
Thu Jun 23 09:13:50 CDT 2005

See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"TiemG" <TiemG@discussions.microsoft.com> wrote in message
news:AAB201D1-05EE-4C67-9EA1-541A04B0D8D1@microsoft.com...
> Hello,
> I made a few macro's and i wan't to share them with other people. The
> macro's are on a server. How can I do this?
> Greets,
> Jan Willem

Jonathan
Thu Jun 23 14:20:17 CDT 2005


"TiemG" <TiemG@discussions.microsoft.com> wrote in message
news:2C6D2495-7DB5-4E17-AEAF-5834605716B3@microsoft.com...
>I did that but then I get an error on the following statement:
> NormalTemplate.AutoTextEntries("TEXT").Insert Where:= _
> Selection.Range, RichText:=True
> Has this something to do with the fact that the macro is in the startup
> folder? Because when I insert the macro in the User template folder then
> the
> macro does work correctly.

Is there an Autotext entry called TEXT in normal.dot?

--
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

TiemG
Fri Jun 24 01:58:01 CDT 2005

I have added an autotext, I added that one into my new template. Do I need to
use an other statement than: NormalTemplate.AutoTextEntries()?

"Jonathan West" schreef:

>
> "TiemG" <TiemG@discussions.microsoft.com> wrote in message
> news:2C6D2495-7DB5-4E17-AEAF-5834605716B3@microsoft.com...
> >I did that but then I get an error on the following statement:
> > NormalTemplate.AutoTextEntries("TEXT").Insert Where:= _
> > Selection.Range, RichText:=True
> > Has this something to do with the fact that the macro is in the startup
> > folder? Because when I insert the macro in the User template folder then
> > the
> > macro does work correctly.
>
> Is there an Autotext entry called TEXT in normal.dot?
>
> --
> 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
>
>

Jonathan
Fri Jun 24 07:19:10 CDT 2005


"TiemG" <TiemG@discussions.microsoft.com> wrote in message
news:900086D7-9578-42BD-A455-0ECE7DAB4AA8@microsoft.com...
>I have added an autotext, I added that one into my new template. Do I need
>to
> use an other statement than: NormalTemplate.AutoTextEntries()?

You need to replace that line of code with one which refers to the location
of the autotext entry. currently, the code is expecting to see the aurotext
entry in normal.dot.

If the autotext is in the same template as the code, then this line of code
should be used instead

ThisDocument.AttachedTemplate.AutoTextEntries("TEXT").Insert Where:= _
Selection.Range, RichText:=True


--
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