[RESOLVED] Empty Clipboard

[swoozie]

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

[dmaruca]

Application.DisplayAlerts = False
    Application.Quit

[Siddharth Rout]

Hi

Define this in a module

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...

OpenClipboard 0&
    EmptyClipboard
    CloseClipboard

Hope this helps...