Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy PasteSpecial (XP)

    I have two seperate instances of Excel running and each Copy/PasteSpecial data from different source workbooks to different destination workbooks.

    I'm not sure why I am receiving this error message.

    Thanks for your assistance,
    John
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy PasteSpecial (XP)

    Are you copying in a workbook open in one instance of Excel and then trying to paste special into a workbook open in the other instance?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy PasteSpecial (XP)

    Hans,

    No, I am always opening in one instance of Excel and within the same instance paste special into another workbook opened with the same instance.

    As an example:

    MainWB_01 opens SourceWB_01 and DestinationWB_01: paste specials into DestinationWB_01
    MainWB_02 opens SourceWB_02 and DestinationWB_02: paste specials into DestinationWB_02

    I am not referencing "ActiveWorkbook" anywhere in the code.

    Regards,
    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy PasteSpecial (XP)

    Without having detailed information about the code and the workbooks it's impossible to tell why the error occurs.

Posting Permissions

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