Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-09-2023, 12:00 AM
syl3786 syl3786 is offline How to copy text from Word to Excel according to a list? Windows 10 How to copy text from Word to Excel according to a list? Office 2019
Advanced Beginner
How to copy text from Word to Excel according to a list?
 
Join Date: Jan 2023
Posts: 97
syl3786 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Did you change the path to reflect the empty workbook name? The "Microsoft Excel 16.0 object library is not required to be checked.

Yes. I had changed the path to reflect the empty workbook name. Now it can run. I mistakenly forgot to change the sheet name......

Can "If oRng.Text Like "Speaker*" Then" be changed as "Speaker 1", "Speaker 2" etc? Since I need to input some names other than "Speaker".....
Reply With Quote
 

Tags
excel copy text, word macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text To Copy From Excel To Relevant Word Document Covert Codger Word VBA 4 07-27-2022 11:40 PM
How to copy text from Word to Excel according to a list? how to copy different text from word into excel on consecutive rows mihnea96 Word VBA 4 05-08-2017 12:09 PM
how to copy addresses in word document to excel/mailmerge list msnarayanan Mail Merge 4 10-17-2015 03:17 PM
Copy Underline text from Word and Paste into excel rfaris Excel Programming 7 10-05-2015 05:56 AM
How to copy text from Word to Excel according to a list? copy a specific words to excel list romanticbiro Word VBA 12 12-03-2014 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft