Text boxes will never be copied in any version of Excel. the boxes are
not part of the worksheet object. Boxes are just a type of shape that
sits ontop of the workksheet and is not part of the worksheet object.

I would also add the Reference in the Access VBA Tool menu for eacel so
you don't have to use the number -4142 and -4143. Go to menu Tools -
Refernce
and add the following library


Microsoft Excel Object 11.0 library (or latest version on your version
of Access)


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=157453

Microsoft Office Help