Marcos all over the place on different computers / in different documents

[Johnnyboy5]

New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

 

[Jay Freedman]

Read http://www.word.mvps.org/FAQs/MacrosVBA/OrganizeMacros.htm.

You may have a problem getting your macros to be available as you move from one computer to another with just what's available on a pen drive. The only way to be sure they'll be there is to store all
the macros needed by each document *in that document*, because you won't have the document's base template or your global templates available except on your own computer. Of course, that causes Word's
antivirus protection to either disable macros or pop up a message warning that you might destroy the world by enabling horrible macros, depending on the macro security setting on that particular
computer. :-(

 

[Graham Mayor]

As we have discussed privately, these 'documents' should be templates, and
the ones I have assisted you with are saved as templates. The macro code is
stored in those templates, so by creating new documents from them, the
macros become available (subject to the macro security set on the PC). Once
you have created the documents, the macros only remain available while they
can see the template containing them. If you transfer the document to
another PC, the template with the macros is not available to it. See also
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

 

[Spoonerism]

Oh the relief! When I saw the thread title I thought 'Another new expression
and/or acronym -- I shall never get the hang of this...


New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

 

[Johnnyboy5]

As we have discussed privately, these 'documents' should be templates, and
the ones I have assisted you with are saved as templates. The macro code is
stored in those templates, so by creating new documents from them, the
macros become available (subject to the macro security set on the PC). Once
you have created the documents, the macros only remain available while they
can see the template containing them. If you transfer the document to
another PC, the template with the macros is not available to it. See alsohttp://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



New to macros  !

I am getting in a right mess with my marcos,  I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc  If I copy and paste them I get in even more
of a mess,  e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

Fair comment Graham - but the last one you kindly sent back to me had
the spelling macro missing and I tried to paste it back in and "messed
it up" but I have sat down had a stiff drink and sorted it out -
there are two marcos now safely attached to that template. I printed
the above post and will have a go this weekend to try and understand
more about sorting them out. What fun learning is, everyday can be
a school day.

 

[Johnnyboy5]

Readhttp://www.word.mvps.org/FAQs/MacrosVBA/OrganizeMacros.htm.

You may have a problem getting your macros to be available as you move from one computer to another with just what's available on a pen drive. The only way to be sure they'll be there is to store all
the macros needed by each document *in that document*, because you won't have the document's base template or your global templates available excepton your own computer. Of course, that causes Word's
antivirus protection to either disable macros or pop up a message warningthat you might destroy the world by enabling horrible macros, depending onthe macro security setting on that particular
computer. :-(

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ:http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroupso all may benefit.








- Show quoted text -

Thanks - printed it out and will have a go this weekend. Just got to
get my head around where and how these marcos work and how to use them
on fly...

John

 

[Johnnyboy5]

New to macros  !

I am getting in a right mess with my marcos,  I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc  If I copy and paste them I get in even more
of a mess,  e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

OMG - I have just seen my bad spelling sorry I did mean MACROS lol

 

[Graham Mayor]

I noticed that the spelling macro was missing after I had posted it. I
assumed that you would quickly discover that and copy it back from the
earlier version.

You are trying to run before you can walk - it's a tempting option and we
have all been there

I think I have posted both links before, but take a look at
http://www.gmayor.com/installing_macro.htm
and http://gregmaxey.mvps.org/VBA_Basics.htm

When you become a bit more proficient, and once you start working with
ranges it will start to fall into place, then for your particular projects,
you should be working with userforms, which are a much more elegant way of
managing your data. I will mail you a template, which is not a complete
replacement for your document by any stretch of the imagination, but it
points the way and shows a few techniques. However, before you attempt to go
there - you will need to readup on the basics, see Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

As we have discussed privately, these 'documents' should be templates, and
the ones I have assisted you with are saved as templates. The macro code
is
stored in those templates, so by creating new documents from them, the
macros become available (subject to the macro security set on the PC).
Once
you have created the documents, the macros only remain available while
they
can see the template containing them. If you transfer the document to
another PC, the template with the macros is not available to it. See
alsohttp://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



New to macros !

I am getting in a right mess with my marcos, I have some attached to
documents, some appear to only be on the actual PC I am using in work.
Others on my laptop etc If I copy and paste them I get in even more
of a mess, e.g. they don’t run …or only some of them run.

How can I get the marcos back together and stay attached to the
document on my pen drive in order that I can use them on any computer
I need to.

Johnnyboy

Fair comment Graham - but the last one you kindly sent back to me had
the spelling macro missing and I tried to paste it back in and "messed
it up" but I have sat down had a stiff drink and sorted it out -
there are two marcos now safely attached to that template. I printed
the above post and will have a go this weekend to try and understand
more about sorting them out. What fun learning is, everyday can be
a school day.