Place Metric units in parenthesis behind English units

JaapOnFire · #1 06-03-2014, 07:13 AM

Hi there,

This is my first question and I think it should be easy enough if I can get some quick pointers in the right direction. Not too familiar with VBA in word (2007).

Here is the outline for what I wish to accomplish:

(1) Find each instance of "gpm" in my document. // gpm = gallons per minute
(2) Find the numerical value preceding this instance (engVal).
(3) Convert this value by multiplying it by a new value
metVal = engVal * 3.785 //convert to liters per minute
(4) Replace the "engVal gpm" string by "engVal gpm (metVal lpm)"
(5) Go to the next instance of "gpm" and ask whether to replace or not.

I rather manually confirm than do the whole document at once since there might be instances of "gpm" (table column headers) where I don’t want to replace it.

When I know how to do this for “gpm”, I can use it for other unit conversions as well.

Any help would be highly appreciated.

Kindest Regards,

Jaap

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
ch and line as measurement units	Aston	Word	5	01-09-2020 04:19 PM
How do I reset the default measurement units to cms	robin_	Excel	2	04-14-2014 10:36 PM
Measurement units in Word	Aston	Word	1	08-16-2013 06:10 PM
Units not properly updated after a Finish Date Change	zi1	Project	1	08-04-2012 05:55 AM
Roll-Up Duration: Changing Units of Measure & Also Accuracy Of	Pmacdaddy	Project	3	04-20-2012 07:13 AM