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.

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