Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to prevent zero error message for logarithmic plots | Charts and Charting in Excel | |||
Is it possible to prevent error message displays? | Excel Programming | |||
How to prevent error message during macro | Excel Programming | |||
How to write a formula that will prevent appearance ERROR MESSAGE | Excel Worksheet Functions | |||
Prevent Error Message | Excel Programming |