Please help copy inside brackets

		Microsoft Office Forums > Microsoft Word > Word VBA
Please help copy inside brackets

FAQ

Thread Tools

Display Modes

#37

02-05-2012, 04:45 AM

macropod

Windows 7 64bit Please help copy inside brackets

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,523

hi Jana,

Replace:

Code:

                'StrTxt = StrTxt & Left(oPara.Range.Text, Len(oPara.Range.Text) - 1) & ", "

with:

Code:

                StrTxt = StrTxt & Left(oPara.Range.Text, Len(oPara.Range.Text) - 1)
                While Right(StrTxt, 1) = "."
                  StrTxt = Left(StrTxt, Len(StrTxt) - 1)
                Wend
                StrTxt = StrTxt & ", "

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Gray square brackets	waldux	Word	8	09-25-2013 04:14 PM
Find/Replace Brackets Problem	fatso	Word	2	08-04-2011 11:34 AM
brackets citation	uncung	Word	1	07-13-2011 01:39 PM
Brackets Issue...	DarkJudge1	Outlook	0	07-06-2010 05:15 PM
copy a file which does not have copy option	jkind	Word	0	01-17-2010 09:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 PM.