G
Guest
hi,
I have the following:
Workbooks.Open "filename.csv"
DisplayAlerts = False
If Range("A2").Value > 0 Then 'file not empty
Range(Range("A2"), Range("O2").End(xlDown)).Select
Range(Range("A2"), Range("O2").End(xlDown)).Copy
Application.ActiveWorkbook.Close savechanges:=False ' No need to save here
End If
But I noticed when the file closes, I get a message:
"There is a large amount of information on the clipboard. Do yo uwant to be
able to paste this information into another program later?"
I need to know how to prevent getting prompted this, and to see WHY I am
prompted?
Thanks in advance,
geebee
I have the following:
Workbooks.Open "filename.csv"
DisplayAlerts = False
If Range("A2").Value > 0 Then 'file not empty
Range(Range("A2"), Range("O2").End(xlDown)).Select
Range(Range("A2"), Range("O2").End(xlDown)).Copy
Application.ActiveWorkbook.Close savechanges:=False ' No need to save here
End If
But I noticed when the file closes, I get a message:
"There is a large amount of information on the clipboard. Do yo uwant to be
able to paste this information into another program later?"
I need to know how to prevent getting prompted this, and to see WHY I am
prompted?
Thanks in advance,
geebee