Word - Problem Accessing Macro on Network Drive Using Shortcut

Asked By billbell52

02-Feb-10 06:31 PM

I have a small network with 12 PCs all running word 2003 and Windows
XP.  There is a word macro on a network drive.  I have a link in the
startup directory pointing to the macro.  This seems to work on most
PCs but there are a few that have problems.  On the ones it does not
work it looks like it ignores the link.  I can double click the link
and it starts word and the macro correctly.  This means the network
and link are ok.  I can put the macro in the startup dir and it runs
correctly.  I have disabled/removed anti-virus/firewall programs.  I
am thinking some word security feature got installed on an update but
all PCs have the same version with the latest updates.  I have Medium
security set for word.  Any ideas?

I am thinking of some work arounds like have a word macro on each PC
and on word startup check to see if the network copy is newer and copy
it over to the local startup directory.  Need to figure out how to
make sure this macro executes first.  What order does word use when
starting macros?

Any other ideas?

02-Feb-10 07:44 PM

See the article "Distributing macros to other users" at:
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

03-Feb-10 12:53 PM

Thanks. I had seen that before. Do you know if a link to a startup
macro should work?  Before I attempt to write some self installing
login script (which I have no clue how to do) I want to determine the
cause of the problem.  Some PCs work fine. I am thinking it might be
easier to write a short 10 line VBA script that does the checking and
put in the startup dir.


vps.org/FAQs/MacrosVBA/DistributeMacros.htm
on

03-Feb-10 06:46 PM

I have no idea what you mean in your description of your current situation
of having


or what you mean by


Perhaps if you explained in detail what the former (present situation) is,
someone could offer a solution.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

Thanks. I had seen that before. Do you know if a link to a startup
macro should work?  Before I attempt to write some self installing
login script (which I have no clue how to do) I want to determine the
cause of the problem.  Some PCs work fine. I am thinking it might be
easier to write a short 10 line VBA script that does the checking and
put in the startup dir.

04-Feb-10 04:25 PM

In

C:\Program Files\Microsoft Office\OFFICE11\STARTUP\macro_lnk.dot

macro_lnk.dot is a shortcut that points to S:\word\macros\macro.dot.
S:\ is mount to a network drive.  macro.dot is the actual word macro.

So I would say it is the first one.  This works on some PCs which is
confusing.

n
,
on

05-Feb-10 08:09 PM

C:\Program Files\Microsoft Office\OFFICE11\STARTUP\macro_lnk.dot

macro_lnk.dot is a shortcut that points to S:\word\macros\macro.dot.

No, it is not a shortcut.  It does not point to anything (except itself).  A .
DOT file in Startup loads the code of that DOT file.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/201002/1

07-Feb-10 01:42 PM

I am not sure what you mean.  macro_lnk.dot is a shortcut.  In Windows
Explorer it lists it as a shortcut.  If you right click macro_lnk.dot
the target is listed as S:\word\macros\macro.dot.

I know this shortcut works because I double click it and it starts
word and the macro runs fine.  Also this works on 8 of 12 PCs. So when
word starts it sees the macro_lnk.dot file, it resolves to the target
location and it loads the macro from the target location.  I have
working on my PC running Vista and Word 2003.  It is just a few PCs
that have a problem.  For some reason it does not resolve the target
or ignores it.

Try it for yourself.


). =A0A .

rd-programming/201002/1