Referencing other workbooks

  • Thread starter Thread starter Bob Kilmer
  • Start date Start date
B

Bob Kilmer

Do the Copy on one line, then then PasteSpecial.


Windows("TEMP.XLS").Sheets("Sheet1").Range"B3").Copy
Windows("ORIG.XLS").Sheets("Sheet1").Range"B3").PasteSpecial (xlPasteAll)

should work.
 
Is it pooable to paste something into another open workbook without
activating it?

such as :-

Windows("TEMP.XLS").Sheets("Sheet1").Range("B3").PasteSpecial (xlPasteAll)

instead of :-

Windows("TEMP.XLS").Activate
Sheets("Sheet1").Range("B3").PasteSpecial (xlPasteAll)
Windows("ORIG.XLS").Activate
 
or if not that, this will copy from specified range from TEMP.XLS to
specified range of ORIG.XLS

Workbooks("TEMP.XLS").Worksheets("Sheet1").Range("A1").Copy
Workbooks("ORIG.XLS").Worksheets("Sheet1").Range("A1").PasteSpecial
Paste:=xlPasteAll
 
Back
Top