+ Reply to Thread
Results 1 to 3 of 3

Sporadic Run-time error 4605 no clear purpose

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    2

    Sporadic Run-time error 4605 no clear purpose

    Hi, I have a long module written to copy data from an excel sheet to a new word document.

    I sporadically get the error message saying:

    "run-time error 4605
    This method or property is not available because the clipboard is empty or not available"
    Stepping into debugger it stops here: "wdApp.Selection.Paste"

    It seems to occur randomly (different places, different times and sometimes runs with no issues).

    I have tried adding DoEvents and tried to use Application.CutCopyMode = False but still occurs.

    Does anyone have any other ideas how to stop this error occuring.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Sporadic Run-time error 4605 no clear purpose

    My suggestion is to place your DoEvents in more places. When you switch between different programs the timing is*unknown.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    01-17-2017
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    2

    Re: Sporadic Run-time error 4605 no clear purpose

    Thanks for the suggestion.
    I already had one DoEvent between each copy and paste command. I added one to before every copy as well but still causing the same problem.
    There are approximately 120 copy commands in the code
    Any other suggestions

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to debug a random and very sporadic ERROR?
    By amartinez988 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2016, 07:14 PM
  2. [Solved] Run-time Error 4605 - Clipboard is empty - Excel Table to Word
    By junino78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2015, 12:57 PM
  3. run-time error 4605 when using a macros in excel 2010 (windows 7)
    By rpt21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2015, 12:49 PM
  4. [SOLVED] Error code 4605 which seems random in appearance - Excel 2010
    By Storm85 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-30-2014, 05:08 PM
  5. Run-time error '4605' This command is not available
    By duugg in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2010, 09:14 AM
  6. Error 4605 - PasteSpecial from Excel To Word
    By austinad in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2009, 10:58 AM
  7. [SOLVED] Run time error '4605' while copying excel range as picture in Wor
    By Samirkc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2006, 10:50 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1