View Single Post
 
Old 09-20-2022, 01:25 PM
effimera effimera is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2021
Posts: 8
effimera is on a distinguished road
Default VBA for duplicating text after slash

Hi there,

I wonder, in MS Word, if is possible to create a macro that can put a slash after every sentence (let's say right before a paragraph symbol) and at the same time duplicate the sentence (the whole sentence without the slash at its end). Is it even possible in text boxes and tables too?
I also tried to make use of regular expressions; unfortunately, it didn't work for text boxes and tables. I need to maintain the original formatting so I think the VBA might help.

For example:

Original formulation:
If you chose this option on your enrollment form, please allow up to 45 days for the premium withdrawal to be set up.

Target reconstruction should look like this:
If you chose this option on your enrollment form, please allow up to 45 days for the premium withdrawal to be set up./If you chose this option on your enrollment form, please allow up to 45 days for the premium withdrawal to be set up.

The point is that, upon running VBA, I need to hide the first (original) part in order to import and translate the file in a CAT tool with the target file being then exported and the hidden text deactivated; thus resulting in a bilingual document (with two languages divided by a slash).
Please is there any way out?

Thank you for any idea.

Irene
Reply With Quote