Disable Message box during VBA Execution

[alexxgalaxy]

Good day!

I searched from the net for the VBA that helps to copy data from a number of files (xls, xlsx, htm, txt, etc) saved in the same folder to another workbook and found the following one. It worked well except a message says "There is a large of amount of information on the Clipboard. Do you want to be able to paste this information into another program later?" kept popping up and I needed to click "Yes", "No" or "Cancel" multiple times so that the macro could go on. I found out from the net that the second codes below could serve that purpose. How does it fit in the first code code to turn off the pop-up message? If the second code is not applicable, how do I code to bypass the pop up?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alexxgalaxy]

Can anybody help?

[VBA FTW]

When do you get the message? When closing the workbook you've opened via code, or when trying to save the workbook your macro is in? Have you tried putting the 2nd bit of code right before the Application.ScreenUpdating = True line?

[alexxgalaxy]

After I ran the code, the message came up (over and over again, I think it amounted to the number of files in the designated folder) and that's why I can't tell where in the 1st code I shall place the 2nd code. I'll try as you advised. Thanks!

[alexxgalaxy]

It didn't work after I put 2nd code right before the Application.ScreenUpdating = True line. The 2nd code closed my file and it's not my intention. I ended up placing them as follows and it worked this time.

Please Login or Register  to view this content.