Copying Raw Field Codes

ptmuldoon · #1 01-03-2015, 07:36 AM

I found this old post/macro Here, but it both gives an error and not sure if will do what I'm trying.

Is there any way to do a global search and replace of text to a Field Code? I have about 70+ tables in Word that are OLE links to an excel file.

An example of one looks like below

Code:

{ LINK  Excel.SheetMacroEnabled.12 "C:\\Data\\Test WPS with Exam Highlights.xlsm" "Cover Charts!Charts_Cover_Main" \p }

and I want to replace both the File Path and File Name with Field Codes like below

Code:

{LINK Excel.SheetMacroEnabled.12 "{DOCPROPERTY  WPFilePath}{DOCPROPERTY  WPFileName}" "Cover Charts!Charts_Cover_Main" \p }

I tried using chr(19) and chr(21) in a replace, but still no luck yet.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to hide field codes from others?	lucky16	Word VBA	2	10-24-2014 03:52 AM
VBA script to update field codes?	Calab	Word VBA	1	04-07-2014 09:27 PM
Formula Field using Field Codes	hunter2193	Word	3	04-05-2013 04:58 AM
Word Equation field codes	mkarthic	Word	1	12-02-2011 02:09 AM
confusion with merge and field codes	BluRay	Mail Merge	5	03-29-2011 01:06 AM