Quote:
Originally Posted by gmayor
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".....