Expression to keep/clear clipboard after Workbooks().close

[vbacoder]

Hi everyone,

I've written some VBA code to copy data from a series of seperate CSVs and apend in a single XL sheet. Rather than leaving the files from which I am copying data open, I would like to close these after pasting in the target file, and I try to do this using:

Workbooks("ExampleFileName.csv").Close SaveChanges:=False

However, before the file closes, a pop-up appears asking if data in the clipboard should be cleared or retained. Please could someone advise me on the way to either retain or clear the data in the clipboard after closing the source file?

vcoder

 

[VoG]

To clear the clipboard and avoid the message

Application.CutCopyMode = False

 

[hippiehacker]

add this line before the close

Application.CutCopyMode = False

 

[Firefly2012]

You can probably just use

Application.DisplayAlerts = False

prior to calling the Close method if you want to retain the data on the clipboard as "Yes" is the default answer to the clipboard data question.