Text Only | Text with Attachments

WestwegoMans' Forum

Computers, Websites & Forums => MS Excel => Topic started by: WestwegoMan on Jan 23, 2015, 5:04 PM

Title: Copy from one workbook and paste to another. (VBA)
Post by: WestwegoMan on Jan 23, 2015, 5:04 PM: To copy from one workbook and paste to another:

Code: [Select]
Windows("workbook1.xls").Activate Sheets("Sheet4").Select Range("A1:D10").Select Selection.Copy Windows("workbook2.xls").Activate Sheets("Sheet4").Select Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _