I'm writing a macro that opens one file, copies the data, closes th
file opens another spreadsheet, pastes the data and then runs anothe
macro.

The macro works but I want to get rid of or answer "yes" to the promp
that asks you if you wish to keep the copied data in the clipboard s
that once the macro runs you don't have to answer any prompts

--
RichardD
-----------------------------------------------------------------------
RichardDC's Profile: http://www.excelforum.com/member.php...fo&userid=1865
View this thread: http://www.excelforum.com/showthread.php?threadid=34587