Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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:

    VB:
    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
    181

    Re: Stopping Large Amount Of Clipboard Data Notification

    Hello,

    How about:

    VB:
    Application.CutCopyMode = False 
    
    
    instead of
    VB:
    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