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?

Thanks

Attached Images

	Old.jpg (56.3 KB, 8 views)
	New.jpg (56.2 KB, 8 views)
	Err 2.jpg (16.1 KB, 8 views)
	Err 1.jpg (39.7 KB, 8 views)

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/