When you copy the data to a new workbook use PasteSpecial using Value
only. I think you are copying links to the new workbook. The links are
getting modified when you are copying the data and point to resources
that are not valid. It is not a problem with something like a memory
resource. Error message in Microsoft tools are vague and sometimes
mis-leading.


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

http://www.thecodecage.com/forumz