Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2014, 05:11 AM
Calab Calab is offline VBA script to update field codes? Windows 7 64bit VBA script to update field codes? Office 2007
Novice
VBA script to update field codes?
 
Join Date: Nov 2011
Location: Alberta, Canada
Posts: 14
Calab is on a distinguished road
Question VBA script to update field codes?

Is the following possible? Is it difficult to code in a VBA script?

At the top of a word document is a table. The first column of the table contains field codes. The second contains values that we want in the field codes.



Whenever I change a value in the second column, I want the rest of the document searched for field codes matching the first column and update their value.
Reply With Quote
  #2  
Old 04-07-2014, 09:27 PM
macropod's Avatar
macropod macropod is offline VBA script to update field codes? Windows 7 32bit VBA script to update field codes? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That's not how fields work. What you need to do is to bookmark the 'Shift' & 'Kaboom!' strings, then insert cross-references to those bookmarks wherever you want their values to appear. Do note that the cross-references won't automatically update - you can achieve that via Ctrl-A, F9.

See also: http://gregmaxey.com/word_tip_pages/repeating_data.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Field codes or Cross referencing Francara Word 3 05-23-2013 03:50 AM
Formula Field using Field Codes hunter2193 Word 3 04-05-2013 04:58 AM
VBA script to update field codes? Word Equation field codes mkarthic Word 1 12-02-2011 02:09 AM
VBA script to update field codes? confusion with merge and field codes BluRay Mail Merge 5 03-29-2011 01:06 AM
VBA script to update field codes? Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 AM.


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