Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Pasting in Data from File Path
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Jul 2011
    Posts
    428
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasting in Data from File Path

    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.

  2. #12
    Board Regular
    Join Date
    Jul 2011
    Posts
    428
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pasting in Data from File Path

    Nevermind - figured it out.

    Code:
    Application.DisplayAlerts=False
    Thanks again Fluff!

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    22,796
    Post Thanks / Like
    Mentioned
    381 Post(s)
    Tagged
    40 Thread(s)

    Default Re: Pasting in Data from File Path

    A better way would be to add this line to the end of the code
    Code:
    Application.CutCopyMode = False
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 2003 & 2013 on Win 7

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •