Bypassing Clipboard operation

hearthhrob4gals · Apr 29th 2020

Code

i wish to copy paste data between 2 workbooks by bypassing the clipboard operation. Th below code works well incase there is a copy paste within the same excel file.
how to modify this to accommodate copy pasting between 2 workbooks (book1.xlx and book2.xlsx)?

Sub copyops()

Call CopyValues(Sheet1.Range("A1:A5"), Sheet1.Range("B1"))

End Sub


Sub CopyValues(rngSource As Range, rngTarget As Range)
 
    rngTarget.Resize(rngSource.Rows.Count, rngSource.Columns.Count).Value = rngSource.Value
 
End Sub




assistance on this would be highly appreciated

Display More

**rory** · Apr 29th 2020

That code will work with separate workbooks. Just qualify the ranges you pass as arguments with the relevant workbook object - note that you can't (easily) use sheet codenames to refer to a sheet in a different workbook to the code.

**rory** · Apr 29th 2020

As with your other post, please provide the relevant cross-posting links.

Bypassing Clipboard operation

Participate now!

Share

Users Viewing This Thread