Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Stop Large Amount Of Data On Clipboard Message

  1. #1
    Join Date
    9th September 2006
    Posts
    10

    Stop Large Amount Of Data On Clipboard Message

    Need some help here... I have some code to open up another workbook, take the data from sheet1 in it, copy it to a sheet in the first book, and then close the opened workbook. My problem is that whenever it closes the workbook it gives me the large amount of data on clipboard window that I must then click 'No' on before it will proceed. I thought that making CutCopyMode = False would fix that, but it hasnt worked. Heres the bit of code that does this:

    Code:
    CutCopyMode = False
        Workbooks.Open Filename:= _
            "G:\Inventory\Inventory.xls"
        Range("A1:M500").Select
        Selection.Copy
        Windows("Inventory Report.xls").Activate
        Sheets("Vis-W").Select
        Cells.Select
        ActiveSheet.Paste
        Range("A1").Select
        Windows("Inventory.xls").Activate
        CutCopyMode = False
        ActiveWindow.Close
        Sheets("Main").Select

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th August 2006
    Location
    Outside St. Louis, MO
    Posts
    621

    Re: Stopping Large Amount Of Clipboard Data Notification

    After you paste the data and before you close the workbook, can you copy say....cell A1 of a particular workbook, so that the data on the clipboard isn't large enough to warrant the message? It's cheesy and inefficient, but will probably work.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th February 2004
    Location
    Florida
    Posts
    189

    Re: Stopping Large Amount Of Clipboard Data Notification

    Hello,

    How about:

    Code:
    Application.CutCopyMode = False
    instead of
    Code:
    CutCopyMode = False
    hth

    JL

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    9th September 2006
    Posts
    10

    Re: Stopping Large Amount Of Clipboard Data Notification

    Mav - its dirty and ugly, but it works, cant believe I didnt think of it! Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    14th July 2007
    Posts
    759

    Re: Stopping Large Amount Of Clipboard Data Notification

    I prefer jlsprink's solution.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    11th August 2006
    Location
    Outside St. Louis, MO
    Posts
    621

    Re: Stopping Large Amount Of Clipboard Data Notification

    Yup. I'm the king of duct taping a project together.

    I would also recommend jlsprink's method.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Report Large Amount of Data
    By wbank in forum EXCEL HELP
    Replies: 5
    Last Post: July 19th, 2007, 19:13
  2. Replies: 4
    Last Post: April 4th, 2007, 18:38
  3. Replies: 5
    Last Post: January 30th, 2007, 00:25
  4. Stop Data On Clipboard Message
    By Frank_ACN in forum EXCEL HELP
    Replies: 3
    Last Post: November 24th, 2006, 11:20
  5. There is a large amount of data...
    By markc in forum EXCEL HELP
    Replies: 1
    Last Post: March 15th, 2005, 04:03

Bookmarks

Posting Permissions

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