I have a macro that copy/paste special values from a csv file into a excel workbook. After every page it asks me if I want to save the info on the Clipboard. What statement or option can I put into the macro so I don't have to keep clicking NO when the box pops up? Here is part of the macro where I think the code or option needs to go in....I just don't know what it is.....
Range("A1:EZ20").Select
Selection.Copy
Windows("Data.xls").Activate
Sheets("R0001").Select
ActiveWindow.ScrollColumn = 1
Range("A1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Windows("R001").Activate
ActiveWindow.Close
Application.CutCopyMode = False
Range("A1").Select

Thank you,
Melinda

Then be sure to include this immediately following the code, or you won't ever get the alerts in this macro.

Works like a charm......after adding in the "=" sign :-)
Thank you!!!
Application.DisplayAlerts = False
Application.DisplayAlerts = True

Melinda

Works like a charm......after adding in the "=" sign :-)
Thank you!!!
Application.DisplayAlerts = False
Application.DisplayAlerts = True

Melinda