Improved way to recognise macros in Word VBA

Copper Contributor

Hello everybody,

 

I was trying to write a macro to turn the following text into a list with a paragraph after each sentence. 

 

Tell me about yourself. What are you doing here? Why consulting? Why did you pick your school? What do you think consultants do? What do you know about this job and our firm? Why would you choose our firm over our competitors? How are your quantitative skills? What percentage is 7 of 63? Tell me of a time you showed leadership skills. 

 

When recording the macro and manually entering a paragraph after each "?" and ".", following code was generated. Is there a possibilty to improve the recognition of macros in a way that Word sees that there is a pattern in when I did a paragraph?

Sub AbsatzNachSatzzeichen()
'
' AbsatzNachSatzzeichen Macro
'
'
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph
Selection.TypeParagraph
Selection.TypeParagraph
Selection.TypeParagraph
Selection.TypeParagraph
End Sub 

 

Thank you very much for your help.

0 Replies