Quick simple question!

[Dermot81]

Hey guys,

I made this little program in VBA, but having some minor issues.

It looks like this:

Workbooks.OpenText FileName:=Sheets("Array Data").Range("B3"), StartRow:=1, DataType:=xlDelimited
Windows("EARRAY").Activate
Sheets("EARRAY").Range("A1:I31").Select
Selection.Copy
Windows("Top Label.xls").Activate
Sheets("Array Data").Select
Range("A6").Select
ActiveSheet.Paste
Windows("EARRAY").Close False

Basically, it opens a txt file into Excel, copies some data, pastes it into another worksheet, and then closes the txt file. Now I have this thing looping for a couple txt files. Problem is I keep getting that msg popup that asks "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later?" Each time I have to keep hitting No for the program to move forward.

Is there any way I can code this into the VBA program, so it automatically answers no to this question?

Thanks a bunch!

[davesexcel]

Workbooks.OpenText FileName:=Sheets("Array Data").Range("B3"), StartRow:=1, DataType:=xlDelimited
Windows("EARRAY").Activate
Sheets("EARRAY").Range("A1:I31").Select
Selection.Copy
Windows("Top Label.xls").Activate
Sheets("Array Data").Select
Range("A6").Select
ActiveSheet.Paste
Windows("EARRAY").Close False
Application.CutCopyMode = False

try adding the above code

[Dermot81]

Figured (Googled) it out a couple hours later.

Thanks though!