Referencing other workbooks
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
"Bob Kilmer" wrote in message
...
Do the Copy on one line, then then PasteSpecial.
Windows("TEMP.XLS").Sheets("Sheet1").Range"B3").Co py
Windows("ORIG.XLS").Sheets("Sheet1").Range"B3").Pa steSpecial (xlPasteAll)
should work.
--
Bob Kilmer
"Stuart" wrote in message
...
Is it pooable to paste something into another open workbook without
activating it?
such as :-
Windows("TEMP.XLS").Sheets("Sheet1").Range("B3").P asteSpecial
(xlPasteAll)
instead of :-
Windows("TEMP.XLS").Activate
Sheets("Sheet1").Range("B3").PasteSpecial (xlPasteAll)
Windows("ORIG.XLS").Activate
|