Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-25-2015, 12:22 AM
gmayor's Avatar
gmayor gmayor is offline FileSaveAs and UpdateAllFields macros not working in new document Windows 7 64bit FileSaveAs and UpdateAllFields macros not working in new document Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

There are questions
What do you mean by 'macros in the footer?' You can't have macros in a footer. You can have them act on a footer but then you say your document is DOCX format and that cannot store macros, so where have you stored the macros?
For macros to work on any document they must be stored in a global template. By default that would be the normal template.

It would help if you posted your FileSaveAs code so we can see what the macro does.

For an update all fields macro - take a look at the example code at http://www.gmayor.com/installing_macro.htm This will cover most situations - certainly fields in header/footers.

The FileSaveAs macro would have to either determine the name with which the document is to be saved, then write it to the footer, or apply it to a docvariable field in the footer, or it would have to save the document, update the filename field then save it again to store the new value.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
FileSaveAs and UpdateAllFields macros not working in new document Can DocumentBeforeSave replace FileSaveAs Macer Word VBA 2 06-05-2015 10:03 PM
FileSaveAs and UpdateAllFields macros not working in new document This macros are not working in office english version 2007 hans Excel Programming 4 12-10-2011 07:03 AM
FileSaveAs and UpdateAllFields macros not working in new document Macros not working when template is emailed EMH Excel Programming 1 07-06-2011 09:24 AM
FileSaveAs and UpdateAllFields macros not working in new document Macros not working in word 2010 louise_chapman Word VBA 3 10-25-2010 08:34 AM
FileSaveAs with Code bsmith Office 0 01-05-2006 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 PM.


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