Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Macros and/or document updating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ITHelpdesk - 19 Sep 2007 20:58 GMT
I have a situation and am not sure how to handle it.  I have a disaster
recovery document that has to be updated frequently and sent to all the team
players.  Ideally I would like to update it in one place and automatically
send to all participants.  Or, I would like to send the document through
e-mail and launch a macro to automatically save the updated document to the
desktop.  Any ideas?  I've seen the Sharepoint Server docs but my network
guys don't really want to set this up.
Chip Orange - 20 Sep 2007 15:14 GMT
How about writing a macro for the document that intercepts the document
close event; tests to see if it's been changed; if so, asks the user if the
change should be sent to everyone, and if so, automatically emails a copy of
the document to them?  This won't cause it to automatically be saved by the
recipiants, but at least you've reasonably assured yourself that it's
getting to them every time it changes.

If they're logging into the same network as you are, then you could do
something with login scripts to cause the new copy to be pushed to their
desktops without having to use a sharepoint server (just use xcopy with the
/d and /y switches as part of a login script).

hth,

Chip

>I have a situation and am not sure how to handle it.  I have a disaster
> recovery document that has to be updated frequently and sent to all the
[quoted text clipped - 5 lines]
> desktop.  Any ideas?  I've seen the Sharepoint Server docs but my network
> guys don't really want to set this up.
src - 20 Sep 2007 17:14 GMT
I did a similar thing recently:  An add-in template that is used
company wide needed to be updated on each user's machine when a new
version came out.

Instead of emailing and relying on the user to install the latest
version, we set up a Login Script that runs a simple batch file:

XCOPY "\\SERVER1\Shared\Reference\Templates\GlobalMacros.dot" "C:
\Documents and Settings\%username%\Application Data\Microsoft\Word
\STARTUP\" /D /Q /Y /R /I /C /K /S

When a user logs into their machine, the batch file runs.  If a new
version is on the server, it copies it to the local machine.

Good luck!

> How about writing a macro for the document that intercepts the document
> close event; tests to see if it's been changed; if so, asks the user if the
[quoted text clipped - 21 lines]
> > desktop.  Any ideas?  I've seen the Sharepoint Server docs but my network
> > guys don't really want to set this up.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.