Letting others use routines I've written

My VBA programming has always been only for myself, up to now. But I've created a document conversion program that is needed by others, and I cannot get it to work on their computers. I copied the template to a network drive, then copied from there to Word's Templates directory on a co-worker's computer. Then I attached it to the document that he wanted to convert, but when I bring up the Macros dialog, the list of macros is blank, even when I specify the template name in the "Macros in" box.

So there's something I'm missing about the VB environment. Also, it would be nice if, on other machines, users did not have to first attach the template to the document before using it. Any help appreciated.

Christopher Brewster
Lockheed Martin

--
Message posted via http://www.officekb.com

Jean-Guy
Tue Jan 11 13:26:15 CST 2005

Christopher Brewster via OfficeKB.com was telling us:
Christopher Brewster via OfficeKB.com nous racontait que :

> My VBA programming has always been only for myself, up to now. But
> I've created a document conversion program that is needed by others,
> and I cannot get it to work on their computers. I copied the template
> to a network drive, then copied from there to Word's Templates
> directory on a co-worker's computer. Then I attached it to the
> document that he wanted to convert, but when I bring up the Macros
> dialog, the list of macros is blank, even when I specify the template
> name in the "Macros in" box.
>
> So there's something I'm missing about the VB environment. Also, it
> would be nice if, on other machines, users did not have to first
> attach the template to the document before using it. Any help
> appreciated.
>

Have you tried placing the template in the user's Word Start-up folder?
Then it will become a global template with its macros/toolbars/autotexts
available to all opened documents (without attaching it).

See what this folder is from Tools > Options... > File Locations tab.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Christopher
Tue Jan 11 15:22:12 CST 2005

[2nd attempt to post. Sorry if duplicated.]

Thanks for the responses. I did as you suggested, putting the template in the Startup folder, but it still doesn't work. The problem may be in how I created the template. I developed the code in my Normal template. When it was ready, I copied the modules I needed into a new template. This is the template that is on the network drive. Is there a better way to create this?

Christopher Brewster

--
Message posted via http://www.officekb.com

Jonathan
Tue Jan 11 16:16:32 CST 2005


"Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
message news:92cf824af6614fcba0ffcd1c6ec9adc2@OfficeKB.com...
> My VBA programming has always been only for myself, up to now. But I've
> created a document conversion program that is needed by others, and I
> cannot get it to work on their computers. I copied the template to a
> network drive, then copied from there to Word's Templates directory on a
> co-worker's computer. Then I attached it to the document that he wanted to
> convert, but when I bring up the Macros dialog, the list of macros is
> blank, even when I specify the template name in the "Macros in" box.
>
> So there's something I'm missing about the VB environment. Also, it would
> be nice if, on other machines, users did not have to first attach the
> template to the document before using it. Any help appreciated.


Hi Christopher

This article may help you

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


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Charles
Tue Jan 11 16:33:35 CST 2005

You'll seldom want to copy entire modules from normal.dot, especially the
New Macros module which is where recorded macros are stored. Use the vba
editor to copy individual macros. Although I'll sometimes start with a macro
recorded or written in normal.dot, I will usually record or write it
directly in the template I'll be using. It just seems easier to do it that
way, to me.

To be more help, people here will need to actually see your code, know what
it is you are trying to do, how it works when it is on your system, and how
it doesn't work when in an Add-In.

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.

"Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
message news:a36ee8411fb94b45b450ce63b47ca456@OfficeKB.com...
> [2nd attempt to post. Sorry if duplicated.]
>
> Thanks for the responses. I did as you suggested, putting the template in
> the Startup folder, but it still doesn't work. The problem may be in how I
> created the template. I developed the code in my Normal template. When it
> was ready, I copied the modules I needed into a new template. This is the
> template that is on the network drive. Is there a better way to create
> this?
>
> Christopher Brewster
>
> --
> Message posted via http://www.officekb.com

Alex
Tue Jan 11 20:15:06 CST 2005

... and make sure your users have macro security set to something other than
"High"

--
Please reply to NG only. This email is not monitored.
Alex.


"Charles Kenyon" <msnewsgroup@remove.no.spam.addbalance.com> wrote in
message news:eBmEX2C%23EHA.2700@TK2MSFTNGP14.phx.gbl...
> You'll seldom want to copy entire modules from normal.dot, especially the
> New Macros module which is where recorded macros are stored. Use the vba
> editor to copy individual macros. Although I'll sometimes start with a
> macro recorded or written in normal.dot, I will usually record or write it
> directly in the template I'll be using. It just seems easier to do it that
> way, to me.
>
> To be more help, people here will need to actually see your code, know
> what it is you are trying to do, how it works when it is on your system,
> and how it doesn't work when in an Add-In.
>
> 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.
>
> "Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
> message news:a36ee8411fb94b45b450ce63b47ca456@OfficeKB.com...
>> [2nd attempt to post. Sorry if duplicated.]
>>
>> Thanks for the responses. I did as you suggested, putting the template in
>> the Startup folder, but it still doesn't work. The problem may be in how
>> I created the template. I developed the code in my Normal template. When
>> it was ready, I copied the modules I needed into a new template. This is
>> the template that is on the network drive. Is there a better way to
>> create this?
>>
>> Christopher Brewster
>>
>> --
>> Message posted via http://www.officekb.com
>
>

Charles
Wed Jan 12 07:55:35 CST 2005

Or that your macros are in trusted locations / templates.
--

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.

"Alex Ivanov" <consul@collegeclub.com> wrote in message
news:uy7mIyE%23EHA.3892@TK2MSFTNGP10.phx.gbl...
> ... and make sure your users have macro security set to something other
> than "High"
>
> --
> Please reply to NG only. This email is not monitored.
> Alex.
>
>
> "Charles Kenyon" <msnewsgroup@remove.no.spam.addbalance.com> wrote in
> message news:eBmEX2C%23EHA.2700@TK2MSFTNGP14.phx.gbl...
>> You'll seldom want to copy entire modules from normal.dot, especially the
>> New Macros module which is where recorded macros are stored. Use the vba
>> editor to copy individual macros. Although I'll sometimes start with a
>> macro recorded or written in normal.dot, I will usually record or write
>> it directly in the template I'll be using. It just seems easier to do it
>> that way, to me.
>>
>> To be more help, people here will need to actually see your code, know
>> what it is you are trying to do, how it works when it is on your system,
>> and how it doesn't work when in an Add-In.
>>
>> 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.
>>
>> "Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
>> message news:a36ee8411fb94b45b450ce63b47ca456@OfficeKB.com...
>>> [2nd attempt to post. Sorry if duplicated.]
>>>
>>> Thanks for the responses. I did as you suggested, putting the template
>>> in the Startup folder, but it still doesn't work. The problem may be in
>>> how I created the template. I developed the code in my Normal template.
>>> When it was ready, I copied the modules I needed into a new template.
>>> This is the template that is on the network drive. Is there a better way
>>> to create this?
>>>
>>> Christopher Brewster
>>>
>>> --
>>> Message posted via http://www.officekb.com
>>
>>
>
>

Christopher
Wed Jan 12 15:08:06 CST 2005

My previous post was premature. Now I remember how I got in the fix: when I do all that I described, the resulting project is unviewable. I was trying to make a template separate from normal.dot that would allow me to develop in it. I can't think of any way to make it "cleaner" than the way I've done it. Any more suggestions? Thanks.

Christopher Brewster
Lockheed Martin

--
Message posted via http://www.officekb.com

Christopher
Wed Jan 12 15:25:13 CST 2005

To answer my own question: I needed to do these things:

- copy the modules from Normal.dot into my new template
- delete the same modules from Normal.dot
- leave the new template in my Templates directory
- put the new template in the other user's Word Startup directory

Now I can develop within the new template, and the other guy can use the macros without attaching to each doc. It's all so clear now!

Christopher Brewster
Lockhee Martin

--
Message posted via http://www.officekb.com

Jonathan
Wed Jan 12 15:25:38 CST 2005


"Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
message news:0da0447c7ca1464cb4294b8b1183575a@OfficeKB.com...
> My previous post was premature. Now I remember how I got in the fix: when
> I do all that I described, the resulting project is unviewable. I was
> trying to make a template separate from normal.dot that would allow me to
> develop in it. I can't think of any way to make it "cleaner" than the way
> I've done it. Any more suggestions? Thanks.

Create a new blank template. With the template open, press Alt-F11 to open
the VBA editor. In the project pane in the top left, you can click and drag
modules from one template to another. Then save the new template with the
module. Check that everything is there before deleting the modules from
normal.dot.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Charles
Wed Jan 12 16:15:11 CST 2005

You can develop in a template that is loaded as an Add-In (in the Startup
folder); you simply have to open the template (like you would open a
document). This gives you access to the vba project.
--

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.

"Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
message news:bd329968d2834673b2b794bc75dd29e6@OfficeKB.com...
> To answer my own question: I needed to do these things:
>
> - copy the modules from Normal.dot into my new template
> - delete the same modules from Normal.dot
> - leave the new template in my Templates directory
> - put the new template in the other user's Word Startup directory
>
> Now I can develop within the new template, and the other guy can use the
> macros without attaching to each doc. It's all so clear now!
>
> Christopher Brewster
> Lockhee Martin
>
> --
> Message posted via http://www.officekb.com

Christopher
Tue Jan 25 14:52:32 CST 2005

I started this thread with a question, got good answers, finished my program, thought I understood the issue, came back to it a week later, and I'm getting "Project is Unviewable". The template is its own project, no duplication with other templates, etc. Maybe I'm dense, but this issue seems unnecessarily difficult. Any suggestions?


To summarize the thread, excerpt of my original:

My VBA programming has always been only for myself, up to now. But I've created a document conversion program that is needed by others, and I cannot get it to work on their computers.

My conclusions after your suggestions:

To answer my own question: I needed to do these things:

- copy the modules from Normal.dot into my new template
- delete the same modules from Normal.dot
- leave the new template in my Templates directory
- put the new template in the other user's Word Startup directory

Now I can develop within the new template, and the other guy can use the macros without attaching to each doc. It's all so clear now!

--
Message posted via http://www.officekb.com

Christopher
Tue Jan 25 14:58:06 CST 2005

Oh, I see the answer in the same thread after my summary note, from Charles Kenyon. Thanks, Charles.

--
Message posted via http://www.officekb.com

Tom
Tue Jan 25 17:09:52 CST 2005

"Project is Unviewable" usally means you are trying to view the code in a
loaded add-in. You'll need to actually OPEN the .DOT file (FILE | OPEN) and
then you should be able to view the code.

--
Tom Winter
Tom@NoSpam.AmosFiveSix.com


"Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
message news:21e9e1f2d4bd407a8927ba75e93c77ea@OfficeKB.com...
> I started this thread with a question, got good answers, finished my
program, thought I understood the issue, came back to it a week later, and
I'm getting "Project is Unviewable". The template is its own project, no
duplication with other templates, etc. Maybe I'm dense, but this issue seems
unnecessarily difficult. Any suggestions?
>
>
> To summarize the thread, excerpt of my original:
>
> My VBA programming has always been only for myself, up to now. But I've
created a document conversion program that is needed by others, and I cannot
get it to work on their computers.
>
> My conclusions after your suggestions:
>
> To answer my own question: I needed to do these things:
>
> - copy the modules from Normal.dot into my new template
> - delete the same modules from Normal.dot
> - leave the new template in my Templates directory
> - put the new template in the other user's Word Startup directory
>
> Now I can develop within the new template, and the other guy can use
the macros without attaching to each doc. It's all so clear now!
>
> --
> Message posted via http://www.officekb.com

Alex
Tue Jan 25 19:47:34 CST 2005

If all you need is to modify the code, it's better to create a new document
based on the template - double-click the .dot file.
Thus you won't accidentally corrupt the contents of the template while
debugging the code. You can save the vb project from the code window, but
changes made to visual appearance of the resulting new document won't be
saved in the template.

HTH

--
Please reply to NG only. This email is not monitored.
Alex.


"Tom Winter" <tom@nospam.amosfivesix.com> wrote in message
news:%2364sCIzAFHA.2076@TK2MSFTNGP15.phx.gbl...
> "Project is Unviewable" usally means you are trying to view the code in a
> loaded add-in. You'll need to actually OPEN the .DOT file (FILE | OPEN)
> and
> then you should be able to view the code.
>
> --
> Tom Winter
> Tom@NoSpam.AmosFiveSix.com
>
>
> "Christopher Brewster via OfficeKB.com" <forum@OfficeKB.com> wrote in
> message news:21e9e1f2d4bd407a8927ba75e93c77ea@OfficeKB.com...
>> I started this thread with a question, got good answers, finished my
> program, thought I understood the issue, came back to it a week later, and
> I'm getting "Project is Unviewable". The template is its own project, no
> duplication with other templates, etc. Maybe I'm dense, but this issue
> seems
> unnecessarily difficult. Any suggestions?
>>
>>
>> To summarize the thread, excerpt of my original:
>>
>> My VBA programming has always been only for myself, up to now. But
>> I've
> created a document conversion program that is needed by others, and I
> cannot
> get it to work on their computers.
>>
>> My conclusions after your suggestions:
>>
>> To answer my own question: I needed to do these things:
>>
>> - copy the modules from Normal.dot into my new template
>> - delete the same modules from Normal.dot
>> - leave the new template in my Templates directory
>> - put the new template in the other user's Word Startup directory
>>
>> Now I can develop within the new template, and the other guy can use
> the macros without attaching to each doc. It's all so clear now!
>>
>> --
>> Message posted via http://www.officekb.com
>
>