Working with Embedded Excel Sheets in Word

I didn't want to cross post, but your rules wouldn't let me apply link to other post.

Greetings from an Excel Nub.

I have an outdated Word form with an embedded excel spreadsheet. I need to move the values from the outdated form to an embedded excel spreadsheet in an updated Word form. See Old.jpg and New.jpg


Part of problem is the row headings in the old form do not align or match with the row headings in the new form.

I have cobbled together the following code which is working "reasonably" well: (will post in follow up because of length restrictions)


Questions:
1. Curious if anyone has suggestions for improving, simplifying, or abandoning this course altogether and doing this a different way.
2. You will see, I've added several "Kill time" features. During development and testing, I would frequently get the following error messages: (See Err 1.jpg and Err 2.jpg)
which are much less frequent with these hard coded delays. Anyone have ideas or suggestions as to why this happens and how to avoid completely?

Please Login or Register  to view this content.

Thanks
Attached Images