Clipboard Event Handler?

Hi,

I'm creating a macro that basically opens up a bunch of spreadsheets,
copies the information, pastes it into a database and closes the
spreadsheets without saving them.


All of this is working fine - the problem I'm having is when my macro
attempts to close each open workbook I get a prompt message from the
Clipboard Event asking if I want to save the copied information on the
clipboard. I want to tell
my macro to tell this prompt "no" don't save the info, but am not sure
how to deal with a Clipboard Event Handler.


Anyone have any advice?


Thanks

After copying the information, try
Application.CutCopyMode = False

or, you can disable alerts before closing the workbooks
Application.DisplayAlerts = False

set it back to True afterwards.


"[email protected]" wrote:

> Hi,
>
> I'm creating a macro that basically opens up a bunch of spreadsheets,
> copies the information, pastes it into a database and closes the
> spreadsheets without saving them.
>
>
> All of this is working fine - the problem I'm having is when my macro
> attempts to close each open workbook I get a prompt message from the
> Clipboard Event asking if I want to save the copied information on the
> clipboard. I want to tell
> my macro to tell this prompt "no" don't save the info, but am not sure
> how to deal with a Clipboard Event Handler.
>
>
> Anyone have any advice?
>
>
> Thanks
>
>