Problem Accessing Macro on Network Drive Using Shortcut
in [Word VBA]
|
Prev: Naming a formfield
Next: Deleting Styles From Organizer
From: billbell52 on 2 Feb 2010 17:25 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?
From: Doug Robbins - Word MVP on 2 Feb 2010 19:44 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. "billbell52" <billb(a)ti.com> wrote in message news:2a371181-b582-4935-aa42-ed43dd68d857(a)c29g2000yqd.googlegroups.com... >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?
From: billbell52 on 3 Feb 2010 12:42 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. On Feb 2, 6:44 pm, "Doug Robbins - Word MVP" <d...(a)REMOVECAPSmvps.org> wrote: > 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. > > "billbell52" <bi...(a)ti.com> wrote in message >
From: Doug Robbins - Word MVP on 3 Feb 2010 18:46 I have no idea what you mean in your description of your current situation of having "a link in the startup directory pointing to the macro." or what you mean by "a link to a startup macro" 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. "billbell52" <52.bill.bell(a)gmail.com> wrote in message news:d4544a0f-92d8-4df0-a2f1-8a6fbc83120a(a)b10g2000yqa.googlegroups.com... 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. On Feb 2, 6:44 pm, "Doug Robbins - Word MVP" <d...(a)REMOVECAPSmvps.org> wrote: > 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. > > "billbell52" <bi...(a)ti.com> wrote in message >
From: billbell52 on 4 Feb 2010 15:10
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. On Feb 3, 5:46 pm, "Doug Robbins - Word MVP" <d...(a)REMOVECAPSmvps.org> wrote: > I have no idea what you mean in your description of your current situation > of having > > "a link in the startup directory pointing to the macro." > > or what you mean by > > "a link to a startup macro" > > 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. > > "billbell52" <52.bill.b...(a)gmail.com> wrote in message > |