1,510 questions
Word maceo to paste specific text feom a word file into new excel file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 66%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nagul
1
Reputation point
Hi May I request you all to help me for a macro to find and paste specific text from a word file into a new excel file.
The macro should copy any name which is appear either below or next to a text says "Name of person" however, do not pick any other rest of the words from the next paragraph onwards. Then paste the text nto a new Excel file.
Example:
Name of person Dr. Peter Paul G
Voluntarily retired
So, the macro should copy and paste only the word Dr. Peter Paul G
I have so many similar instances in my word document, so pls help me to extract
Developer technologies | Visual Basic for Applications
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChristyZhang-MSFT 26,126 Reputation points Microsoft External Staff2022-12-19T02:06:41.3+00:00 Hi @ Nagul-6471 ,
Welcome to our forum!
Looks like your issue is more related to vba, please kindly understand that the Outlook tag here we mainly focus on general issues about Outlook desktop client. In order to better solve your problem, we will remove "office-outlook-itpro" add "office-vba-dev" tag.
Thanks for your understanding and hope your issue would be resolved soon.
Sign in to comment
Sign in to answer