|
|
|
|
#1
04-08-2023, 08:56 PM
|
||||
|
||||
Did you change the path to reflect the empty workbook name? The "Microsoft Excel 16.0 object library is not required to be checked.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com 
|
|
#2
04-09-2023, 12:00 AM
|
|||
|
|||
|
Quote:
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".....
|
|
| Tags |
| excel copy text, word macro |
| Thread Tools | |
| Display Modes | |
|
|
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 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 |
|
copy a specific words to excel list
|
romanticbiro | Word VBA | 12 | 12-03-2014 05:12 AM |
Windows 10 
Office 2019
Hybrid Mode