i only use xl2003, and one of my clients has both xl2002 and xl2003. on the
xl2002 boxes, my code comes up with a message about there being a large amount
of data on the clipboard and the macro halts.

i believe it's this line,
ActiveSheet.Copy
which just copies the current sheet to a new workbook.

since i don't have xl2002 installed, i was wondering if someone could help me
out.

--


Gary

Try
Application.cutcopymode=false

after the copy operation.

Tim

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i only use xl2003, and one of my clients has both xl2002 and xl2003. on the
xl2002 boxes, my code comes up with a message about there being a large
amount of data on the clipboard and the macro halts.

i believe it's this line,
ActiveSheet.Copy
which just copies the current sheet to a new workbook.

since i don't have xl2002 installed, i was wondering if someone could help
me out.

--


Gary

i have that in here already

--


Gary


"Tim" <tim j williams at gmail dot com wrote in message
...
Try
Application.cutcopymode=false

after the copy operation.

Tim

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i only use xl2003, and one of my clients has both xl2002 and xl2003. on the
xl2002 boxes, my code comes up with a message about there being a large amount
of data on the clipboard and the macro halts.

i believe it's this line,
ActiveSheet.Copy
which just copies the current sheet to a new workbook.

since i don't have xl2002 installed, i was wondering if someone could help me
out.

--


Gary

i found the problem, it wasn't the line of the copy, it was the subsequent
pastespecial line. i moved the application displayalerts=false and the macro
just went to the error handler routine without pasting anything. so i removed it
completely and found that they created their master sheets with MERGED CELLS
and it threw and error when it tried to paste the values.



--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i only use xl2003, and one of my clients has both xl2002 and xl2003. on the
xl2002 boxes, my code comes up with a message about there being a large amount
of data on the clipboard and the macro halts.

i believe it's this line,
ActiveSheet.Copy
which just copies the current sheet to a new workbook.

since i don't have xl2002 installed, i was wondering if someone could help me
out.

--


Gary