Pasting in Data from File Path

nirvehex

Active Member
Joined
Jul 27, 2011
Messages
486
That worked! I do get an annoying pop up box that says "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later?" Yes No Cancel

Anyway to avoid this popping up or just close it automatically with the VBA?

Thanks for helping with the weird tweaks! Sorry for the hassle.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

nirvehex

Active Member
Joined
Jul 27, 2011
Messages
486
Nevermind - figured it out.

Code:
Application.DisplayAlerts=False
Thanks again Fluff!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,895
Office Version
365
Platform
Windows
A better way would be to add this line to the end of the code
Code:
Application.CutCopyMode = False
 

Watch MrExcel Video

Forum statistics

Threads
1,095,992
Messages
5,447,783
Members
405,464
Latest member
Jayne125

This Week's Hot Topics

Top