Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2010, 12:37 PM
systechguy systechguy is offline Word Macros Windows XP Word Macros Office 2003
Novice
Word Macros
 
Join Date: Mar 2010
Posts: 1
systechguy is on a distinguished road
Default Word Macros

I have an interesting problem.



My boss would like to have a dynamic filename and path associated with certain documents that are stored on a public server.

Every time the filename or location of the file has changed, the filename and path in the header will change also.

I have found the code for the macro to do this here:
http://support.microsoft.com/?kbid=832897

There might be different people moving these documents around.

It seems when I enable this macro, it works from my Word application, but not if someone else moves or renames the Word file.

Is there a way to enable this feature so no matter who is changing the filename or moving the document, the filename and path will change?
Reply With Quote
  #2  
Old 03-23-2010, 04:48 AM
Guessed's Avatar
Guessed Guessed is offline Word Macros Windows Vista Word Macros Office 2007
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Is the code embedded in the document itself or does it reside in the attached template or does it reside in your own Normal.dot?

If the macro is not in the document then do the other users have access to the same template filepath?

If the other users have disabled macros (this is on by default) then your macro won't run unless the document (or template) which houses the macro is stored in a 'trusted location'.

As you can see, using a macro is not pure and simple when lots of people are going to be using the file.
Reply With Quote
  #3  
Old 07-12-2010, 01:26 PM
Leanne 33 Leanne 33 is offline Word Macros Windows XP Word Macros Office 2003
Novice
 
Join Date: Jul 2010
Posts: 1
Leanne 33 is on a distinguished road
Default Macros and Trusted Source

How do you ensure the document housing the macros is saved as a trusted source?

I have a lot of documents with the same macros. The documents are saved on a server accessed by different users. Each time the documents are accessed, the disable/enable macros security warning message appears. How can I saved the documents on the server as a trusted source?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Macros kenny@kennyn.com Word VBA 0 02-09-2010 09:54 AM
Macros in Word khamilton Word 0 11-22-2009 06:38 PM
Macros in Word Jehanzeb Word 0 11-12-2009 04:43 AM
Macros & Passwords paulrm906 Excel 0 03-04-2006 01:30 AM
Self Help Books for Macros? KRB Excel 0 11-22-2005 01:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft