Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
I am trying to copy a specific range from multiple workbooks to a single file for data comparison.
I have 10+ workbooks that need the same range in each copied to different columns in a new workbook.
I have code that lets me browse to the folder that has my workbooks to copy from and move through each.
My problem is the copy and paste, after it does the copy paste and then tries to close the workbook I am prompted for "there is a large amount of data in the clipboard do you want to save it for later"
Is there a way to turn that off or automatically reply no?
I have 10+ workbooks that need the same range in each copied to different columns in a new workbook.
I have code that lets me browse to the folder that has my workbooks to copy from and move through each.
My problem is the copy and paste, after it does the copy paste and then tries to close the workbook I am prompted for "there is a large amount of data in the clipboard do you want to save it for later"
Is there a way to turn that off or automatically reply no?