View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geebee Geebee is offline
external usenet poster
 
Posts: 28
Default prevent error message

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