[RESOLVED] Empty Clipboard

When you close an excel file using VBA. How can you stop or send no to the propmt of Empty or save clipboard?

VB Code:

Application.DisplayAlerts = False
    Application.Quit

Hi

Define this in a module

VB Code:

Declare Function CloseClipboard Lib "user32" () As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long

and

then use this before quiting...

VB Code:

OpenClipboard 0&
    EmptyClipboard
    CloseClipboard

Hope this helps...